workbook links, remove a bad one

[Dave Welsh]

I have a workbook with a link to a workbook that no
longer exists. I can't figue out how to remove move it.
There is nothing listed in any of my books or the help
file. Has anyone seen a procedure, anywhere. I'd love to
get rid of the message window when the file opens up.

 

[Gord Dibben]

Dave

You could have a link in a named range. Check Insert>Name>Define on each
sheet.

Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site.

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

With this add-in you can find and delete links.