Removing Links

[Alan Dresch]

Some time ago I pasted a worksheet from one workbook to
another. The original workbook was deleted, and now I get
a message on opening the new workbook reminding me that
there is a link in place.

I can see the Link in Edit/Links but do not know how to
remove it.

Thanks for your Help

Alan Dresch

 

[Mark]

See the article from the knowledge base..

http://support.microsoft.com/default.aspx?scid=kb;en-
us;214127

 

[Frank Kabel]

Hi Alan
the following add-in will help you to delete these links
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

 

[Max]

Try Bill Manville's excellent FindLink utility

It's usually* available at Stephen Bullen's page:
http://www.bmsltd.co.uk/MVP/Default.htm
(*but think Stephen's site is down currently)

Here's an alternative download thrown up via a web search:
http://www.accountingadvisors.com/exdownload.shtml

Look for:
Find and Remove Links
Bill Manville's excellent utility FINDLINK.XLA

--
Rgds
Max
xl 97

 

[Stephen Bullen]

Hi Max,

It's usually* available at Stephen Bullen's page:
http://www.bmsltd.co.uk/MVP/Default.htm
(*but think Stephen's site is down currently)

My .co.uk is no longer under my control, but the files can be
downloaded from my .ie site:

http://www.bmsltd.ie/MVP/Default.htm

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie

 

[Max]

Thanks for the update, Stephen !
Pleased to know that.

 

[Dave Peterson]

I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager to make that name visible.
http://www.jkp-ads.com/Download.htm

(You can use the name manager to delete the name or use findlink.)

That said, I just created a hidden name that pointed at another workbook and
findlink deleted it for me.