I have Microsoft Office 2010 Home and Student. I have cells from one page linked to another page within the same workbook. When the data changes from the source cell it does not reflect a change in the destination cell unless I double click the destination cell at which point it refreshes. Some of my links update on their own and others require manual refresh. I never know which links are correct and up to date without double checking the values in all of the destination links and comparing to the source cell for accuracy. As a result I cannot trust the calculations in my workbook.

Can anyone tell me a fix to this problem?

• Edited by LONNIEBEAUCHAMP 13 hours 52 minutes ago

What kind of links are you referring to? Are those formulas linked to other sheets?

A likely cause is that Calculation is set to manual. To change this to automatic:

File > Options > Formulas > Workbook Calculation > Automatic.