excel 2000 doc looks for pages in the local drive b4 opening

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Excel doc is looking for pages of the doc in my local drive b4 opening. I have hit cancel for every page it does not find and then it opens. Other excel docs open with no prob. Doc in question was created by someone else. Any suggestions please?
 
I'm guessing you have links to workbooks on your local drive that can't be
found.

You're job will be to figure out if you can destroy the links or if you should
find the real location and use that.

There's an option in Tools|Options|Edit tab that allows you to be prompted if
excel should go off and try to update the links (check the "ask to update
automatic links" box).

Then the next time you open the workbook, you'll be prompted. Answer no (to
save clicking time) and then you can use:

Edit|Links
to change them.

In fact, sometimes these links are difficult to find. I'd use Bill Manville's
findlink.zip from:
http://www.BMSLtd.co.uk/MVP/Default.htm
for the really buried ones.

But it's my guess, that you should answer "No" so the links aren't updated. I
bet the developer of the workbook kept the links by mistake and wants you to use
the current values.

Check with that person to make sure.
 
Back
Top