The missing links...
Posted by Matt on July 19, 2001 2:21 PM
Hi all. Im 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 cant 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 Ive missed, or are they left over garbage that just needs to be cleaned up?
Any help or suggestions would be appreciated. Thanks in advance.