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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

working with excel 97 workbooks 5
Excel 97 2
Transfering files from Open Office Calc to EXCEL 8
EXCEL 97 WORK IN 2007? 2
Excel 97 3
how do i defalt save as excel 97 ? 1
Excel checkbook register 2
open excel 8

Back
Top