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)
Quaisquer soluções e/ou desenvolvimento de aplicações pessoais, ou da empresa, que não constem neste Blog podem ser tratados como consultoria freelance.
Excel 2013 - Especificações e Limitações - Specifications and Limitations
Não existe nada melhor do que conhecer o ambiente onde trabalhamos ou desenvolvemos. Precisamos compreender as exatas especificações e limitações.
Sim, volto a deixar no original, para que nada possa perder-se por causa da tradução.
Deixe os seus comentários! Envie este artigo, divulgue este link na sua rede social...
Tags: VBA, Excel,