Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Excel 2003 & 2007 formula compatibility

I have a user who built a big spreadsheet in Excel 2003. This spreadsheet
contains many formulas that depend on many cells. When the spreadsheet,
created in Excel 2003, is opened in Excel 2007, many of the cells say #NA.
When one looks at the formula in Excel 2007, the formula states =#NA instead
of the actual formula. This creates of chain of many cells displaying #NA.

For example, the formula for 2003 is: =EOMONTH(cell number)
formula for 2007: =#NA

Trying to trace the error gives me: The Error Tracer encountered existing
arrows or a circular reference. Delete all tracer arrows or resolve the
circular reference, and then choose Trace Error again.

Now if the same spreadsheet is opened in another computer in 2003,
everything is fine. If one retypes the same formula in 2007, everything will
also be okay.

Is there a known compatibility issue between Excel 2003 and 2007? Is there
something that I am missing?

Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 -- 2003 Compatibility dgold82 Excel Discussion (Misc queries) 2 June 30th 09 08:10 PM
Compatibility Problem Excel 2003 x 2007 gdanilo Excel Discussion (Misc queries) 1 December 30th 08 11:02 PM
Compatibility Problem between Excel 2003 and 2007 gdanilo Excel Worksheet Functions 2 December 30th 08 08:22 PM
Excel 2003 and Office 2007 Compatibility Bob Excel Discussion (Misc queries) 1 December 5th 08 04:58 AM
Excel 2007/2003 Pivottable compatibility Michael Anderson Excel Discussion (Misc queries) 0 February 21st 08 02:55 AM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"