When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Pele wrote:

I have an excel worksheet that has links to other files; when it opens, I
tell Excel NOT to update the links (this I believe will ensure that only the
newest data in the remote file will be updated). There are two problems with
this linked file.

1) When it open up, the file does not update with the newest data from the
source. But when I go to each cell and press F2 and Enter, then it updates.
It should have updated automatically.

2) I used Edit Links and it shows a link to a source file that should not
have been there. I tried to find where that link occured in an equation, but
I couldn't. How do I go about tracking down the link or removing this source
file.

Any advice will be appreciated.

Pele

--

Dave Peterson