Excel 97 to Excel 2000 Problems

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

HELP!

We are just about to convert our users to Office 2000 from
Office 97. One user, in finance, has several linked
spreadsheets, which when opened in 97 are fine, yet when
they are opened in 2000 come up with #REF errors in most
of the cells, even when you choose not to update links,
unless you have the Autocalculation off, in which case it
is fine, until you hit F9.

Is there a difference between the way 97 handles the
update compared to the way 2000 handles it?

If so, is there a switch or something we can invoke to
prevent this happenening.

Or finally, does anyone have ideas how I might resolve
this. PLEASE :)

Christine

ps any questions you may have please ask, as I really need
to resolve it.
 
Just a guess but has the defacult faolder changed with the upgrade to
XL2003?
Do the the links point at the correct folder?
Bernard
 
Back
Top