Ghost links in Workbook
 

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.

Hi ASinghBama

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"ASinghBama" wrote in message ...
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.

It works. Thanks!

--
_Ajay


"Ron de Bruin" wrote:

Hi ASinghBama

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"ASinghBama" wrote in message ...
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.