Removing Unwanted Links

[J. Heseltine]

Is there a method of simply removing external links from
Excel spreadsheets. It seems that unwanted links can creep
in as a result of copying portions of spreadsheets. They
can't be found using ! in spreadsheets with multiple
sheets as individual sheets within the spreadsheet are
also identified with an !. Is there any other way of
identifying the link.

Better yet, if the link is doing nothing (which it must be
in the case with which I am dealing) is there no way of
simply deleting the link?

 

[John Wilson]

J. Heseltine,

It sounds like you'll want to do this on a regular basis??
If so, check out Bill Manville's FindLink Add-In:

http://www.bmsltd.co.uk/MVP/

John