Excel Specifications Limitations

Home/Excel/Excel Specifications Limitations
Below are the list of Excel-2013 Specifications and Limitations:

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)
LIMITED TIME OFFER
By |March 2nd, 2013|Excel|1 Comment

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

One Comment

  1. Mack July 18, 2017 at 6:09 AM - Reply

    Why the limit of ‘Largest allowed positive number via formula 1.7976931348623158e+308’ in Excel 2010

Leave A Comment


Related pages


unprotect an excel workbook without passwordexcel userform listboxexcel vba column rangehow do i get rid of duplicates in excelexcel vba application.getsaveasfilenamecreate macros in excel 2007carriage return excelhow to title columns in excelcreate a check box in excelclear filter vbaexcel macro arrayvba message box examplecheck marks in exceldefine variables in vbadashboard excel tutorialexcel vba snippetsexcel exercises for beginnersfree gantt charts in excelpivot table excel vbaexcel vba datevaluesimple dashboard in excelvba excel programming exampleshow to delete the empty rows in excelpivot table 2010 tutorialuse vlookup in vbaexcel macro text boxvb msgboxasap utilities 64 bit downloadcombining if statements in excelvba beginners tutorialdatediff in vbalearn to write vba code for excelvba pivot table source datarun sql in vbacopy worksheet to new workbookset row height in excel 2010merging cells in excel 2010excel delete sheethow to combine cells in excel 2007excel layout templatesbutton vbaexcel vba add hyperlink to cellhow to select rows in excelhot to merge cells in excelvba new linertrim vbaturn off autofilter vbawhat is ddl commandisna formula in vlookuphide worksheet in excelexcel vba worksheetfunctionaccess iif statement with multiple conditionshow to unhide column a in excel 2013excel substitute formulainsert comment excelunlocking password protected excel filehow to remove the blank rows in exceldashboard in excel tutorialtesting questions for freshersvba sheet protectiondocmd.opentablehow do you delete rows in excelexcel test for blank cellmodules in excel vbamacro to copy worksheetpricing model template in excelcounta vbavlookup basicsunprotect the excel sheetcalculate weeks between two dates excelvba sort rangevba drop downvba sort ascendingexcel templates dashboarddatevalue functionexcel 2013 column widthpassword lock excelforgot password of excel protected sheetmicrosoft excel advanced filter