Removing unwanted link

[Ian Page]

I don't know how, but somehow a massive XL workbook I'm developing has
picked up a link to a workbook I have discarded. I want to delete the link,
but don't know where it is.

I have searched for a text string containing a unique part of the name of
the linked workbook - not a trivial exercise as my workbook contains over 20
worksheets, and as far as I can tell I have to search each worksheet
seperately - but I still can't find the link.

Any other ideas?

 

[Peo Sjoblom]

Try Bill Manville's free add-in FindLink

http://www.bmsltd.ie/MVP/MVPPage.asp



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Jim Gordon MVP]

Hi,

If you are using Excel 2004 just go to the Edit menu. Choose Links, then
click the "Break Link" button.

-Jim

 

[Ian Page]

Thanks Peo, worked a treat. Thank God for guys like you and guys like Bill.

And Jim, that link-breaker sounds like a welcome addition - but I'm on Mac
Excel X (still waiting for MS to ship Mac Office 2004 Pro - dum-de-dum - any
month now...)

 

[Jim Gordon MVP]

Hi Ian,

I'm glad you've good a good sense of humor

The long wait for VPC7 should be over soon. Windows XP Service Pack 2 is
now complete, and from what I can tell that is what the hold-up was.

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>