How do I break links in a workbook?

Alwebster6635 · Jul 21, 2005

I have 4 worksheets in my workbook that I have linked to a summary file. I
need to be able to save the summary file as a new file and break the link,
but the break link button is not appearing on the link box. What do I do?

Dave Peterson · Jul 21, 2005

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And that break link was added in xl2002 (IIRC).

Phillycheese5 · Jul 21, 2005

Depending on what you need, you could copy and paste the new sheets in
the files as values...

Phillycheese5

Adrian M · Jul 21, 2005

You can use the Find/ Replace feature to find the links and then manually
break them. Look at the Find/ Replace video clip on
http://www.auditexcel.co.za/othertools.html to see how to do it.

How do I break links in a workbook?

Alwebster6635

Dave Peterson

Phillycheese5

Adrian M