dead links

T

tjb

I have a workbook that had links to another document but
now I want to remove those links but I cannot find the
cell that has the links. Every time I open the workbook
it prompts for this linked file since it can't find it,
how do I remove all links to other workbooks?
 
G

Gord Dibben

tjb

The link may not be in a cell.

Could be in a defined name.

Insert>Name>Define. Anything in there that is linked to another file?

Alternative......Download Bill Manville's FINDLINK.XLA from Stephen Bullen's
website.

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

It is a ZIP file. You will need WinZip or similar to open and extract the
FINDLINK.XLA add-in.

Gord Dibben Excel MVP
 
Top