How do I get rid of an external link which I can't find?

R

Ray

I have a spreadsheet that *somewhere* has an external link.

I want to get rid of it, but I need to find the link first to check that I
am not hard-coding over a formula that does actually need to change.

However Excel 2002 is too stupid to show me the actual link. I can "Break
the Link", but since the program refuses to actually direct me to the cell
using the link, that option is no good.

I have also tried using "Find" to look for the cell linking to the external
sheet, but Excel can't find any matches.

I have reviewed the list of defined names in "Insert Name" dialog box; none
of them are external to the worksheet.

This is driving me up the wall. I can't download the utility suggested in a
previous posting, since I am using my work computer and there are strict
rules on downloading anything, let along .xla files.

Someone please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wits end wrt automatic linking 3
How to remove links to external data 0
Linking to a milestone which has an external dependency 0
Automatic update of links has been disabled - how do I get rid of 1
Excel 2000 - How to find cell location of a link to another file? 2
external links 2
FInding external link 1
How do I change the links in Excel at one batch? 1

Top