Linked Workbooks

[Guest]

Hi All,

I'm using Excel 97 at work and there are two workbooks that someone has
linked. I can't figure out how to unlink them. I go under "EDIT", "LINKS"
and can view the linked workbook but see no way to delete the link. In Excel
2003 that I have at home I can delete the link.
Any ideas?

Thanks
Brian

 

[Dave Peterson]

If you search for .xls, you can find the cells with the links.

Then you can copy|paste special|Values.

Sometimes they can hide in hard to find spots.

You could use Bill Manville's FindLink program to help find them:
http://www.bmsltd.ie/MVP/Default.htm

 

[Rich]

Hi, I have the same problem caused by working in one workbook and then
sending a copy to another workbook. Sometimes I've found that I am linked to
several books and computers after a copying to yet another book and
installing on another computer. Its possible to remove all but one link
using EDIT/LINKS. However entering the problem in GOOGLE got me to MrExcel
an then Microsoft MSDN site and search for Q Article q188449 a Delete Links
Wizard. I've not had time to try it yet so I hope it works!!!!

 

[Guest]

Hey Rich, That's exactly my problem. I'm going to give it a try.

Thanks
Brian

 

[Guest]

Thanks Rich and Dave for helping me.

Brian

Hey Rich, That's exactly my problem. I'm going to give it a try.

Thanks
Brian

linked