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?

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).

Alwebster6635 wrote:

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

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

Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=389102

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.

"Alwebster6635" wrote:

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?