MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Link Problem

Posted by Terry Ernst on August 02, 2001 9:14 AM

Each time I open a worksheet it asks if I want to update
the file. I always say yes because I do have active
links that I want to update from. However, the sheet
also tries to update from another source that I don't
have any references to. I've used the Find function to
try and locate the file but the results are negative.
I cannot locate any reference to the file (workbook1.xls)
and I'm not sure what to try next.

Posted by Barrie Davidson on August 02, 2001 9:18 AM

Have a look at the names in the spreadsheet (via Insert|Name|Define), I'll bet your mystery links are there.