How do I break links in a workbook?

[Guest]

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]

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]

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

Phillycheese5

 

[Guest]

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.