How do I break links in a workbook?

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

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

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?

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?

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

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?