If you are using Office 2007 and the files are from 2003, then you need to save both linked files as 2007
I am running Office XP with Service Pack 3 installed on Windows XP Professional. I have links to cells in an Excel file. When I open it and it asks me if I want to update the links in the document, I click yes, but the links do not actually update.
I've reinstalled Office and it has not helped. I tried opening the document on another computer and going through the same process, and the links DO update, so I nkow it's an issue with my PC, not the document. The setting under Tools>Options>General for Update automatic links at open is checked.
What can I do?