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)

Premium Project Management Templates

120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

PREMIUM TEMPLATES
LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS