Microsoft Office Tutorials and References
In Depth Information
Locating Phantom Links
Locating Phantom Links
You might open a workbook and see a message like the one shown in Figure 200-1. If the
workbook contains links, you expect to see this message. But sometimes this message appears even
when a workbook contains no linked formulas.
Figure 200-1: The Excel way of asking whether you want to update links in a workbook.
To get rid of these phantom links, first try clicking the Edit Links button in the dialog box (or
choose File Info Edit Links to Files) to display the Edit Links dialog box. Then select each link
and click Break Link. Save the workbook and reopen it. Note that the Edit Links to Files command
is not available if your workbook contains no links.
If breaking the links doesn’t solve the problem, the phantom link might be caused by an
erroneous name. Erroneous names might be created when you copy a worksheet that contains names.
Choose Formulas Defined Names Name Manager and scroll through the list of names. If you
see a name that refers to #REF!, delete the name. There’s an excellent chance that your phantom
link will disappear.
 
Search JabSto ::




Custom Search