Excel 2007 comes with more powerful and flexible technique you can use to process your worksheet data. In Excel 2007 version, You could always create larger data collections across multiple worksheets. Excel 2007 version is more user friendly interface than Excel 2003. There are many differences between Excel 2007 to Excel 2003. These differences show as a table form :-
| Topic | Excel 2003 | Excel 2007 |
|---|---|---|
| Columns in a worksheet | 256 | 16384 |
| Rows in a worksheet | 65536 | 1048576 |
| No of fields displayed in the Pivot Table Field List | 255 | 16384 |
| Maximum Length (character) of a formula | 1024 | 8192 |
| Color allowed in a workbook | 56 | 4.3 billion |
| No of characters displayed in a cell | 1024 | 32768 |
| No of characters displayed in an Autofilter List | 1024 | 32768 |
| No of columns allowed in a Pivot Table | 255 | 16384 |
| Manubar | Character Based | Character plus Icon Based |
| Fileformat | XLS | (XML Based)XLSX, XLSM, XLTX, XLTM & XLAM |
