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 Sunday, February 15, 2015 9:59 PM

thank you very much for the response. i checked and calculation is and was already set to automatic. 

=MAIN!E2   this is an example of a link that i am referring to. it's a simple link that should carry the value from the original cell to another sheet in the book. i have always been using these and they have always worked fine. now many are not working. and example would be... the value in MAINE2 is sum(E3:E1000) as data is manually entered in column E the value in MAINE2 changes of course. The changes are supposed to carry over to another page automatically to the cell which =MAIN!E2. 

Let's say that the value of MAINE2 started the day at 65 before any data was entered in column E on that page for the day. The linked cell that should be =MAIN!E2 is showing 65 as it should. But at the end of the day after entering in data to column E the value of MAINE2 IS NOW 160. When I check the link on the other page the cell for =MAIN!E2 is still showing a value of the old data of 65. If I double click on the =MAIN!E2 cell it will update it'self to 165 but if I don't double click the cell it will remain at 65 indefinately.

There are many many of these "links" that are doing that. If I want my workbook to be accurate I have to go through constantly and double click all the "links" so that they update to the correct values.

I should add that some links do this and some work fine. It's not an all or nothing scenario. It's seems to be random. I tried to click "refresh all" which does nothing. I think that "refresh all" is meant for data that is originating from a source other than the same workbook? not sure but it doesn't fix my problem. If there is a way to refresh all that would work for me i'd love to know what it is as opposed to refreshing each individual cell one at a time.