Links also can lurk in objects, such as text boxes, autoshapes, etc. Objects can try to reference an external workbook.
The easiest way to locate objects is to select any single cell on each worksheet and then select Edit -> Go To… (F5). From the Go To… dialog, click Special and then check the Objects option and click OK. This will select all objects on the worksheet. You should do this on a copy of your workbook. Then, with all objects selected, you can delete, save, close, and reopen your copy to see whether this has eliminated the problem.
Finally, the last not-so-obvious place to check for real links is in the hidden sheets that you might have cleverly created and forgotten about. Unhide these sheets by selecting Format -> Sheet -> Unhide. If the Unhide option on the Sheet submenu is grayed out, that means you have no hidden sheets. (If you think there are sheets that don't turn up in the menu, see "Hide Worksheets So That They Cannot Be Unhidden" [Hack #5] for more information.)
Now that you have eliminated the possibility of real links, it's time to eliminate the phantom links. Go to the haunted workbook with the phantom links and select Edit -> Links…. Sometimes you can simply select the unwanted link, click Change Source, and then refer the link back to itself. Often, though, you will be told that one of your formulas contains an error, and you will not be able to do this.
LinkBack URL
About LinkBacks
Register To Reply
Always make a backup copy 1st just in case something goes wrong.
]
Bookmarks