#Value and #Ref, links between multiple file not updating

[CA_User]

I have a series of excel files linked to other files. Sometimes the workbook opens with #value, or #REF but the links are not broken... The value ONLY update and show up as numbers (vs errors) when I have the correspnding source file open.

I tried to update the links via "edit links" and Update values. Sometimes when I do that, cells with actual numbers turn into the errors #REF or #value. I then have to open the workbook to get rid of them.

Please help!

 

[CA_User]

Do SUMIF formula update automatically? or is this similar to INDIRECT? What exactly is a function like INDIRECT and why would there be a difference?

 

[Oaktree]

Have a look at:

http://support.microsoft.com/kb/260415/en-us

 

[CA_User]

Thank you so much! this saves me tremendous time!