if you tell Excel NOT to update the links it wont update anything.If you say
yes it will update the links,so anything that has been changed on the other
sheet will update on your new sheet.If you have a unwanted link go to edit
links highlight the link you want to break and select break links
--
paul
remove nospam for email addy!



"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