Ghost links in Workbook

[Guest]

Often times I work with workbooks e-mailed to me. Many of these workbook
contain links to the creator's local files, which are annoying when opening
the workbook. I have erased all the range names that are not used in the
workbook, I have looked for the cell with reference i.e. Edit|Find| in each
of the sheets of the work book and yet no luck. Are there other easy ways to
find the source of the link? Please help , the problem is just very annoying.

 

[Ron de Bruin]

Hi ASinghBama

Try this Add-in to find the links
<findlink.zip>

http://www.bmsltd.ie/MVP/

 

[Guest]

It works. Thanks!

--
_Ajay

Hi ASinghBama

Try this Add-in to find the links
<findlink.zip>

http://www.bmsltd.ie/MVP/