To point out the obvious, if you use any of the new functions available in
Excel 2007 and want to pass that file to someone without 2007, those
functions won't work for them. If you save the file in 97-2003 format, then
you'll be warned of the incompatibilities when you do the save.

There are also some incompatibilities within macro code. There are some new
parameters for some functions that don't exist in earlier versions, and that
would make the code unusable in the earlier versions without modification.
Not a lot of that, but some. We've seen this type of thing during
transitions between other versions in the past, so it's not like this is
something unique to 2007.

"Dan the Man" wrote:

Are there any compatibility issues when transitioning from Excel 2002 to
Excel 2007? I just bought 2007 but haven't installed it yet. I'll assume that
all of my worksheets and formulas will work just the same? I'll also assume
that if I send a 2007 spreadsheet to someone with an earlier version of
Excel, that they will be able to open the file without issue?

Btw, thought I also heard tht Excel 2007 has some incredible new functions,
bells and whistles whcih include the ability to incorporate formulas that can
also perform "countif" functons based upon color. That would be kewl. Does
Excel 2007 also allow logic formulas to be written which "change" the color
of the font when certain parameters are met? For example, when the EDATE
function is employed, can logic be writen to change the color of the font in
a particular row from black to red, once the applicable date has elapsed. For
example if a formula is placed in cell AA3, can that formula include logic to
change the font from black to red once the 3 month date elapses?

IF(A1="","",EDATE(A1,3)

or........

=countif (a formula which only counts certain color fonts or cell shades?)

Can't wait to install Excel 2007!

Dan