Finding and abolishing the LINKS in an Excel file

My former assistant inserted some dynamic LINKS in an Excel sheet we use daily. Each time I open the file, it asks whether I want to update the links. I say yes. Presumably the links pull figures from other files in our server. The answers returned by the Links are not relevant. How can I find these Links and erase them? --thanks, Greg.

 

You can access the links from the EDIT menu.
Since you've probably not used that function, the "Links" selection may not be immediately visible, however, if you hold the cursor over the Edit menu long enough it will appear near the bottom of the list, or if you hit the double down arrow at the bottom of the menu list it should appear.

If the sheet contains off sheet links, it will be enabled.
If not, it will be greyed out.

Once in the "Edit Links" dialog box, one of the otion buttons is "Break Links ".

HOWEVER, I urge caution in this matter.

Presumably the links are there for a reason, and may be used for calculations.
The "Edit Links" dialog box will show you where the linked cells are located, and I suggest you review them BEFORE breaking them.

Additionally, if in fact the links are broken, and then the sheet is saved, they will be permanantly lost, (unless specifically re-established).
The reason I mention this is that I frequently see sheets that are simply too "busy ". Basically, they doo too much, or cover too many areas of interest. Since you state that the links, and their data are not relevant for your particular usage, it seems to imply that perhaps two seperate sheets are more appropriate. If that is the case, BEFORE breaking the links, I'd suggest saving the sheet as a different name, and then work with just the workbook you want. You can then delete the sheets that contain the links, and save the file, and thus your links will also be deleted, but the original sheet will be intact.

 

Bilbo: Thanks for the answer. "Edit>Links" was the trick. I still could not see the target location of the result of the remaining links, but no matter. There was only one link left and it was unnecessary, so I took it out. Thanks, Greg.