dead links

  • Thread starter Thread starter tjb
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
Invisible Link 4
Link? 1
Breaking links between workbooks in Excel 2000 1
Trace links between worksheets within one workbook 4
break link to email workbook 1
Link won't break in Exel. 2
break links not working 39

Back
Top