Hi Dan

If you save the files in 2007 in the new formats of 2007 you can't open the file in 2002.
You have two options

1) install the converter
http://office.microsoft.com/en-us/ex...775611033.aspx

2) save the file in the 97-2003 format

This are the new functions

IFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
SUMIFS Adds the cells in a range that meet multiple criteria
AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
AVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria.
COUNTIFS Counts the number of cells within a range that meet multiple criteria

Cube functions

CUBEKPIMEMBER Returns a key performance indicator (KPI) property and displays the KPI name in the cell.
CUBEMEMBER Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube.
CUBEMEMBERPROPERTY Returns the value of a member property from the cube.
CUBERANKEDMEMBER Returns the nth, or ranked, member in a set.
CUBESET Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set,
and then returns that set to Microsoft Office Excel.
CUBESETCOUNT Returns the number of items in a set.
CUBEVALUE Returns an aggregated value from the cube.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dan the Man" wrote in message ...
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