Updating links Excel 97 to XP ??

  • Thread starter Thread starter Scott Carlson
  • Start date Start date
S

Scott Carlson

Getting #REF errors when opening Client workbook that was created i
Excel 97. I created a workbook with multiple links to external clien
documents (which I no longer have access to) and now when I open th
workbook in Office XP I receive #REF errors in all the cells. I canno
re-link the document since I do not have access to the files any more
Is there any way to transfer the embedded links from the Excel 97 file
 
I may have missed what you are asking for but...At a long shot... you could try: Open Excel (without opening the 97 file). Go to Tools, Options, Calculation (tab). Set Calculation to Manual. Click Ok. Open the 97 file. My guess is that it will show you the formulas that give you the #REF errors. Then you can take steps to point those formulas to another worksheet that you can access?

Don't know if that will work even..

PS: Don't forget to turn calculate back to Automatic or you will regret it later (it stops formulas updating straight away)

regards
Douglas
 
Back
Top