LINKS WONT REFRESH AUTOMATICALLY

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?





February 14th, 2015 6:21am

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.

Free Windows Admin Tool Kit Click here and download it now
February 17th, 2015 9:46am

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.
February 17th, 2015 9:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics