It kind of sounds like the linked workbook has moved (or been deleted).

Any chance that it isn't there anymore?

Something to try...

With the workbook closed,
Tools|Options|Edit tab
Check "Ask to update automatic links"

Then file|open your workbook.

You should be prompted to see if the links should be updated.

I created two workbooks--one with a link to the other. I saved both, but then
deleted the workbook that was linked to. (Book1.xls had a link to book2.xls and
I renamed book2.xls to book2222222.xls.)

I changed that setting. When I opened book1.xls, I got the prompt to update
links. I said no. The workbook opened and I could see where the "sending"
workbook was--so I could verify that it was still there (with the correct
worksheet names).

Maybe it'll work for you.

Mary C wrote:

All of a sudden my Excel 2002 will not open a workbook that contains links to
other workbooks unless the other workbook is open. I get a dialog saying
links could not be updated and to edit them.

Any suggestions from anyone on how to change settings so the linked
workbooks do not need to be open to update?

Thanks.

--

Dave Peterson