Removing Linked Worksheets in Excel

[Matthew W. McCoy]

We have a file that has bounced around over multiple years, under multiple
versions of Excel, that contains links to various Source Files. Whenever
the file is opened, it asks if we would like to update the information in
the linked documents. Click NO makes the file usable, so there is no lost
data. It is just a bit annoying to have to continue to do so.

Some of these files exist, and some have not existed for years. In either
case, we have been unable to remove the link to the files that are
referenced. The status on each of these linked source files is A.

Any ideas/help/direction on removing these source files would be
appreciated.

Thanks,

-matt

 

[Max]

Try Bill Manville's excellent "FindLink" utility

It's available at Stephen Bullen's page:
http://www.bmsltd.ie/MVP/Default.htm

 

[Matthew W. McCoy]

Worked like a charm. Thank you much for the link to the add-in and site.
Much appreciated.

-matt

 

[Max]

You're welcome, Matt!
Glad to help ..