Links not updating...

[Emerlin]

Hi - I have some links across several sheets. Just today they stopped updating for some reason. I have checked the status and everything comes back as "ok". I even have the two sheets open and the values still do not update when I select update values....

I am working in excel 2010, some of the data sheets - are from excel 2003, but they have always updated, until today. ideas?

 

[Emerlin]

Hi - I have some links across several sheets. Just today they stopped updating for some reason. I have checked the status and everything comes back as "ok". I even have the two sheets open and the values still do not update when I select update values....

I am working in excel 2010, some of the data sheets - are from excel 2003, but they have always updated, until today. ideas?

So - I have fixed my own problem found from a post here, although I am not sure why I had the problem the first place. I simply pressed F9 - calculate? I assume the changes the calculation from manual to automatic?

 

[VoG]

No, it forces a recalculation.

To set calculation to Automatic select Options on the File tab then click Formulas.

 

[Emerlin]

No, it forces a recalculation.

To set calculation to Automatic select Options on the File tab then click Formulas.

thanks!