Links to external workbooks

[Gordon]

I need to remove links to external workbooks within a
current Excel file. I have checked and removed range
names as appropriate, searched each sheet for links within
formulae and deleted these, and also checked all graphs.

Is there anywhere else that these links may be hiding?

Thanks,

 

[Katherine Coombs]

I'd check out the dellinks.exe from MS

http://support.microsoft.com/default.aspx?scid=kb;en-us;188449&Product=xlw


HTH,
Katherine

 

[Dave Peterson]

I like this utility from Bill Manville.

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

 

[Jim Cone]

Gordon,

Dave's recommendation for the Bill Manville tool is a good one.

However, an alternative that is very easy to use is my "Locate Links"
add-in.
It provides three options: list all links, delete all links or remove them
one at a time.
If you choose the list option, each item on the list is hyperlinked to (or
near) the link. Its available (free) by direct request - remove the xxx
from my address.

Regards,

Jim Cone
San Francisco, CA
(e-mail address removed)
'***************