Removing links to other workbooks-Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with a spreadsheet/form in Excel 2000 (calculates estimated
relocation costs) that has an old link to a non-existent workbook -- it was
developed from another spreadsheet but is a stand-alone form and there is no
need to update, as must have been the case with the original. The resulting
pop-ups are a problem. I don't work with queries or macros... at least, not
until now, so don't know how to eliminate the unnecessary link(s). Any
suggestions are appreciated.
 
Try going to Edit | Links.
This should list all the links in the workbook.
select the link you want and pick break link.

tj
 
Frank, in researching my problem (cancelling a link in Excel2000) I saw your
name often, so I thought I'd give your suggestion. It did n't work for me.
I have a book that I don't want linked to anything. Break Link is not
available to me under EDIT, LINKS.
Any other suggestions?
 
Try that findlink.zip program.

It'll look for links and ask what should be done with them (convert to values?).
 
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

Linking 2 excel workbooks 1
Link To File That No Longer Exists 1
Excel 2007 Linking Cells 0
move worksheet to end of another workbook 3
Hyperlink to cells in other workbooks keep changing 3
links in protected workbooks 2
XL2000 Links Between Workbooks 2
Quick way for monthly linking of Excel sheets 0

Back
Top