Should you upgrade to Excel 2007?

I always wondered when the 65,536 row limit would be extended for Excel. Now it's ridiculous. Take a look. I'm only going to show the major points here. To see all, visit http://www.mvps.org/visio/Excel_2007.htm.

The total number of available columns in Excel
Old - 256
New - 16000+

The total number of available rows in Excel
Old - 64,000+
New - 1,000,000+

Total amount of PC memory that Excel can use
Old - 1GB
New - Maximum allowed by Windows

Unique Colours Per Workbook
Old - 56
New - 4.3 billion

Number of conditional format conditions on a cell
Old - 3 conditions
New - Limited by available memory

Number of levels of sorting on a range or table
Old - 3
New - 64

Number of items shown in the Auto-Filter dropdown
Old - 1,000
New - 10,000

The total number of characters that can display in a cell
Old - 1k (when the text is formatted)
New - 32k or as many as will fit in the cell (regardless of formatting)

The maximum length of formulas (in characters)
Old - 1k characters
New - 8k characters

The number of levels of nesting that Excel allows in formulas
Old - 7
New - 64

Maximum number of arguments to a function
Old - 30
New - 255

Number of rows allowed in a Pivot Table
Old - 64k
New - 1M

Number of columns allowed in a Pivot Table
Old - 255
New - 16k

Maximum number of unique items within a single Pivot Field
Old - 32k
New - 1M

The number of fields (as seen in the field list) that a single PivotTable can have
Old - 255
New - 16k

A resizeable formula bar

The Name Manager helps organize, update and manage multiple name ranges from a central location.

If you hover over the different table formats in the Table Gallery, you will see a live preview of how your table will look. Some of the formats include alternating colours for rows (usually light and dark). If you delete a row, Excel 2007 will maintain the alternating pattern.

Functions
Yes there are more functions. There are 343 functions with 51 new functions.

CUBERANKEDMEMBER
Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.
Cube

CONVERT
Converts a number from one measurement system to another
Engineering

DELTA
Tests whether two values are equal

SQL.REQUEST
Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming.

Acrobat files
Excel 2007 spreadsheets will also be able to export to PDF. A special PDF writer will no longer be required.