| Worksheet and workbook specifications and limits |
MAXIMUM LIMIT |
| Maximum limits of memory storage and file size for Data Model workbooks |
Depends on System, please refer MSDN |
| Open workbooks |
Limited by available memory and system resources |
| Sheets in a workbook |
Limited by available memory |
| Names in a workbook |
Limited by available memory |
| Windows in a workbook |
Limited by available memory |
| Linked sheets |
Limited by available memory |
| Scenarios |
Limited by available memory; a summary report shows only the first 251 scenarios |
| Custom functions |
Limited by available memory |
| Reports |
Limited by available memory |
| Named views in a workbook |
Limited by available memory |
| Worksheet size |
1,048,576 rows by 16,384 columns |
| Column width |
255 characters |
| Row height |
409 points |
| Page breaks |
1,026 horizontal and vertical |
| Total number of characters that a cell can contain |
32,767 characters |
| Characters in a header or footer |
255 |
| Colors in a workbook |
16 million colors (32 bit with full access to 24 bit color spectrum) |
| Unique cell formats/cell styles |
64,000 |
| Fill styles |
256 |
| Line weight and styles |
256 |
| Unique font types |
1,024 global fonts available for use; 512 per workbook |
| Number formats in a workbook |
Between 200 and 250, depending on the language version of Excel that you have installed |
| Hyperlinks in a worksheet |
66,530 hyperlinks |
| Panes in a window |
4 |
| Changing cells in a scenario |
32 |
| Adjustable cells in Solver |
200 |
| Zoom range |
10 percent to 400 percent |
| Sort references |
64 in a single sort; unlimited when using sequential sorts |
| Undo levels |
100 |
| Fields in a data form |
32 |
| Workbook parameters |
255 parameters per workbook |
| Items displayed in filter drop-down lists |
10,000 |
| Noncontiguous cells that can be selected |
2,147,483,648 cells |
| Calculation specifications and limits |
MAXIMUM LIMIT |
| Worksheet arrays |
Limited by available memory |
| Cross-worksheet array formula dependency |
Limited by available memory |
| Area dependency |
Limited by available memory |
| Area dependency per worksheet |
Limited by available memory |
| Number precision |
15 digits |
| Smallest allowed negative number |
-2.23E-308 |
| Smallest allowed positive number |
2.23E-308 |
| Largest allowed positive number |
1.00E+308 |
| Largest allowed negative number |
-1.00E+308 |
| Largest allowed positive number via formula |
1.7976931348623158e+308 |
| Largest allowed negative number via formula |
-1.7976931348623158e+308 |
| Length of formula contents |
8,192 characters |
| Internal length of formula |
16,384 bytes |
| Iterations |
32,767 |
| Selected ranges |
2,048 |
| Arguments in a function |
255 |
| Nested levels of functions |
64 |
| User defined function categories |
255 |
| Number of available worksheet functions |
341 |
| Size of the operand stack |
1,024 |
| Cross-worksheet dependency |
64,000 worksheets that can refer to other sheets |
| Dependency on a single cell |
4 billion formulas that can depend on a single cell |
| Linked cell content length from closed workbooks |
32,767 |
| Earliest date allowed for calculation |
January 1, 1900 (January 1, 1904, if 1904 date system is used) |
| Latest date allowed for calculation |
31-Dec-99 |
| Largest amount of time that can be entered |
9999:59:59 |
| Charting specifications and limits |
MAXIMUM LIMIT |
| Charts linked to a worksheet |
Limited by available memory |
| Data points in a data series for 2-D charts |
Limited by available memory |
| Data points in a data series for 3-D charts |
Limited by available memory |
| Data points for all data series in one chart |
Limited by available memory |
| Worksheets referred to by a chart |
255 |
| Data series in one chart |
255 |
| PivotTable and PivotChart report specifications and limits |
MAXIMUM LIMIT |
| PivotTable reports on a sheet |
Limited by available memory |
| Row or column fields in a PivotTable report |
Limited by available memory |
| Calculated item formulas in a PivotTable report |
Limited by available memory |
| Calculated item formulas in a PivotChart report |
Limited by available memory |
| Unique items per field |
1,048,576 |
| Report filters in a PivotTable report |
256 (may be limited by available memory) |
| Value fields in a PivotTable report |
256 |
| Report filters in a PivotChart report |
256 (may be limited by available memory) |
| Value fields in a PivotChart report |
256 |
| Length of the MDX name for a PivotTable item |
32,767 |
| Length for a relational PivotTable string |
32,767 |
| Items displayed in filter drop-down lists |
10,000 |
| Shared workbook specifications and limits |
MAXIMUM LIMIT |
| Personal views in a shared workbook |
Limited by available memory |
| Workbooks that can be merged at one time |
Limited by available memory |
| Users who can open and share a shared workbook at the same time |
256 |
| Days that change history is maintained |
32,767 (default is 30 days) |
| 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) |
| Excel tables in a shared workbook |
0 (zero) |
Why the limit of ‘Largest allowed positive number via formula 1.7976931348623158e+308’ in Excel 2010