Excel 2003 and 2010 limits and specifications
Are you interested in the limits of Excel and its comparison to the older and the new version? Then, just for you I have prepared a table of selected specifications and comparisons between versions 2003 and 2010. At the end of the table are cross-referenced to the complete official specs from the Microsoft website. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.
Limits and specifications Excel
| Description | Excel 2003 | Excel 2010 |
| Number of cells in a sheet | 65 536 rows and 256 columns | 1 048 576 rows and 16 384 columns |
| Max. length of a cells content | 32 767 chars | 32 767 chars |
| Limit of sheets in a workbook | limited by PC memory | limited by PC memory |
| Decimal places accuracy | 15 digits | 15 digits |
| Formula length | 1 024 chars | 16 384 chars |
| Function arguments limit | 30 | 255 |
| Merged functions in a formula | 7 | 64 |
| Go back steps | 16 | 100 |
| Dates range | 1.1.1900 – 31.12.9999 | 1.1.1900 – 31.12.9999 |
| Number of PivotTable on the sheet | limited by PC memory | limited by PC memory |
| Row or Column fields in PivotTables | limited by PC memory | limited by PC memory |
| ReportFilter page fields in PivotTables | 256 | 256 |
| Data fields in PivotTables | 256 | 256 |
| Changing cells in scenarios | 32 | 32 |
| Unique values in PivotTable | 32 500 | 1 048 576 |
| Scenario limit | limited by PC memory | limited by PC memory |
| Complete specs link | Excel 2003 specs | Excel 2010 specs |
Zanechat komentář