Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes in Excel 2003
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes in Excel 2003
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. -- Jim "Steve@RDN" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes in Excel 2003
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/groups?thre...GP11.phx .gbl Maybe it'll work for you. Steve@RDN wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |