Changes in Excel 2003

S

Steve@RDN

We have been using Excel 2002 for a few years and have developed complicated
spreadsheets that reference other sheets within the excel spreadsheet as well
as other spreadsheets. When we open these spreadsheets in Excel 2003 we have
many cells that have #REF!. But if you open this document in Excel 2002 it
is fine.

Have there been any changes that would cause this?

Thanks
 
J

Jim Rech

There were remarkably few changes in Excel 2003. I'd look at Tools, Add-ins
in the two versions to see if something is unselected in Excel 2003.
 
D

Dave Peterson

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

Maybe it'll work for you.
 
Top