Excel tip: Excel 2000 limitations/specifications
Date: 5 september 2001| Worksheet and workbook specifications | |
| Feature | Maximum limit |
| Open workbooks | Limited by available memory and system resources |
| Worksheet size | 65,536 rows by 256 columns |
| Column width | 255 characters |
| Row height | 409 points |
| Length of cell contents (text) | 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. |
| Sheets in a workbook | Limited by available memory (default is 3 sheets) |
| Colors in a workbook | 56 |
| Cell styles in a workbook | 4 |
| Named views in a workbook | Limited by available memory |
| Custom number formats | Limited by available memory |
| Names in a workbook | Limited by available memory |
| Windows in a workbook | Limited only by system resources |
| Panes in a window | 4 |
| Linked sheets | Limited by available memory |
| Scenarios | Limited by available memory; a summary report shows only the first 251 scenarios |
| Changing cells in a scenario | 32 |
| Adjustable cells in Solver | 200 |
| Custom functions | Limited by available memory |
| Zoom range | 10 percent to 400 percent |
| Reports | Limited by available memory |
| Sort references | 3 in a single sort; unlimited when using sequential sorts |
| Undo levels | 16 |
| Fields in a data form | 32 |
| Custom toolbars in a workbook | Limited by available memory |
| Custom toolbar buttons | Limited by available memory |
| Calculation specifications | |
| Feature | Maximum limit |
| Number precision | 15 digits |
| Largest allowed positive number | 9.99999999999999E307 |
| Smallest allowed negative number | -9.99999999999999E307 |
| Smallest allowed positive number | 1,00E-307 |
| Largest allowed negative number | -1,00E-307 |
| Length of formula contents | 1,024 characters |
| Iterations | 32,767 |
| Worksheet arrays | Limited by available memory. Also, arrays cannot refer to entire columns. For example, an array cannot refer to the entire column C:C or to the range C1:C65536. However, an array can refer to the range C1:D65535 because the range is one row short of the maximum worksheet size and does not include the entire C or D column. |
| Selected ranges | 2,048 |
| Arguments in a function | 30 |
| Nested levels of functions | 7 |
| Number of available worksheet functions | 329 |
| Earliest date allowed for calculation | January 1, 1900 (January 1, 1904, if 1904 date system is used) |
| Latest date allowed for calculation | December 31, 9999 |
| Largest amount of time that can be entered | 9999:99:99 |
| PivotTable report specifications | |
| PivotTable reports on a sheet | Limited by available memory |
| Items in a PivotTable report | 8 |
| Row or column fields in a PivotTable report | Limited by available memory |
| Page fields in a PivotTable report | 256 (may be limited by available memory) |
| Data fields in a PivotTable report | 256 |
| Calculated item formulas in a PivotTable report | Limited by available memory |
| Charting specifications | |
| Charts linked to a worksheet | Limited by available memory |
| Worksheets referred to by a chart | 255 |
| Data series in one chart | 255 |
| Data points in a data series for 2-D charts | 32 |
| Data points in a data series for 3-D charts | 4 |
| Data points for all data series in one chart | 256 |
| Line styles | 8 |
| Line weights | 4 |
| Area patterns (screen display) | 18 |
| Total area pattern and color combinations (color display) | 56,448 |
| Pattern and color combinations (color printer) | 56,448 (the actual number depends on your printer and its software) |
| Page fields in a PivotChart report | 256 (may be limited by available memory) |
| Data fields in a PivotChart report | 256 |
| Calculated item formulas in a PivotChart report | Limited by available memory |
| Workgroup specifications | |
| Users who can open and share a shared workbook at the same time | 256 |
| Personal views in a shared workbook | Limited by available memory |
| Days that change history is maintained | 32,767 (default is 30 days) |
| Workbooks that can be merged at one time | Limited by available memory |
| Cells that can be highlighted in a shared workbook | 32,767 |
| Colors used to identify changes made by different users when change highlighting is turned on | 32 (each user is identified by a separate color; changes made by the current user are highlighted with navy blue) |
Bas
« back
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.