MrExcel Publishing
Your One Stop for Excel Tips & Solutions

The missing links...


Posted by Matt on July 19, 2001 2:21 PM

Hi all. I’m running Excel 2000. I have a workbook with 100+ worksheets that pull data from 90+ linked files. I am in the process of cleaning up dead links and re-routing them to the new (re-named) files. In order to do this, I answer YES to update the links when the file is opened, write down the links that Excel can’t find, I then use Edit --> Search and find the links within the workbook to verify what they should be (or rather where they should be linking to), and then go in to Edit --> Links to change/update them.

Within the list of 90+ linked files (shown under Edit --> Links) there are a few listed links that the Search tool cannot find in the workbook. Is it possible that these old links have been deleted/overwritten from the workbook, but they are still showing up on the listing found under Edit --> Links? I assumed that the listing given by Edit --> Links was a current, actual listing of the links found in the workbook. Is this true or is this listing more of a snapshot of some point in the workbooks life? Does these links reside somewhere hidden within the workbook that I’ve missed, or are they left over garbage that just needs to be cleaned up?

Any help or suggestions would be appreciated. Thanks in advance.

Matt


Posted by Barrie Davidson on July 19, 2001 2:44 PM

I use Excel97 so I don't know if this applies to your situation but.....have a look at the named ranges. I'll bet you have some named ranges that point to a linked file.

Regards,
Barrie

Posted by Matt on July 20, 2001 11:43 AM

Thanks a bunch Barrie! That was the problem.