are formuals in 2007 compatible with 2003 with the exception of saving the
worksheet as compatible with 2003

Excel 2007 added some new formulas (IFERROR, SUMIFS, and others) so
these will not be compatible with 2003. Also, functions that in 2003
and earlier were part of the Analyis Tool Pack were made native
functions in 2007, so in 2003 you'll have to load the ATP.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 22 Oct 2008 09:43:25 -0700, confused!!
wrote:

are formuals in 2007 compatible with 2003 with the exception of saving the
worksheet as compatible with 2003

Chip has given you a full answer but you might also need to know that XL2007
allows full column references in array formulas. So in XL2007 I can use
=SUMPRODUCT(--(A:A="Apple"),
--(B:B="Granny Smith"), C:C)
This will not work in earlier versions
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"confused!!" wrote in message
...
are formuals in 2007 compatible with 2003 with the exception of saving the
worksheet as compatible with 2003

.... and there's the level of nesting. Is it 64 in 2007 and 7 in 2003? ...
and of course the number of rows and columns available, and ....

A more detailed list of what's different in 2007 is at
http://technet.microsoft.com/en-us/l.../cc179167.aspx and another at
http://office.microsoft.com/en-us/he...738731033.aspx
--
David Biddulph

"Bernard Liengme" wrote in message
...
Chip has given you a full answer but you might also need to know that
XL2007 allows full column references in array formulas. So in XL2007 I can
use =SUMPRODUCT(--(A:A="Apple"),
--(B:B="Granny Smith"), C:C)
This will not work in earlier versions
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"confused!!" wrote in message
...
are formuals in 2007 compatible with 2003 with the exception of saving
the
worksheet as compatible with 2003