Report filters in a PivotTable report: Maximum of 256 filters (may be limited by available memory) Row or column fields in a PivotTable report: Limited by available memory Unique items per field: Maximum of 1,048,576 unique items PivotTable reports on a sheet: Limited by available memory Worksheets referred to by a chart: Maximum of 255 worksheetsĭata series in one chart: Maximum of 255 data seriesĭata points in a data series for 2-D charts: Limited by available memoryĭata points in a data series for 3-D charts: Limited by available memoryĭata points for all data series in one chart: Limited by available memory Excel PivotTable and PivotChart Report Maximum Limits and Specifications Largest amount of time that can be entered: 9999:59:59 Excel Charting Maximum Limits and SpecificationsĬharts linked to a worksheet: Limited by available memory Latest date allowed for calculation: December 31, 9999 Linked cell content length from closed workbooks: Maximum of 32,767Įarliest date allowed for calculation: Janu(January 1, 1904, if 1904 date system is used) Size of the operand stack: Maximum of 1,024Ĭross-worksheet dependency: Maximum of 64,000 worksheets that can refer to other sheetsĬross-worksheet array formula dependency: Limited by available memoryĪrea dependency: Limited by available memoryĪrea dependency per worksheet: Limited by available memoryĭependency on a single cell: Maximum of 4 billion formulas that can depend on a single cell Number of available worksheet functions: Maximum of 341 functions User defined function categories: Maximum of 255 categories Nested levels of functions: Maximum of 64 nested levels Worksheet arrays: Limited by available memoryĪrguments in a function: Maximum of 255 arguments Internal length of formula: Maximum of 16,384 bytes Length of formula contents: Maximum of 8,192 characters Smallest allowed positive number: 2.2251E-308 Smallest allowed negative number: -2.2251E-308 Noncontiguous cells that can be selected: Maximum of 2,147,483,648 cells Excel Calculation Maximum Limits and Specifications Items displayed in filter drop-down lists: Maximum of 10,000 items Workbook parameters: Maximum of 255 parameters per workbook Sort references: 64 references in a single sort unlimited when using sequential sortsįields in a data form: Maximum of 32 fields Scenarios: Limited by available memory (a summary report shows only the first 251 scenarios)Ĭhanging cells in a scenario: Maximum of 32 changing cellsĪdjustable cells in Solver: Maximum of 200 adjustable cellsĬustom functions: Limited by available memory Hyperlinks in a worksheet: Maximum of 66,530 hyperlinks Number formats in a workbook: Maximum between 200 and 250, depending on the language version of Excel installed Unique font types: Maximum of 1,024 global fonts available for use or 512 per workbook Unique cell formats/cell styles: Maximum of 64,000 Maximum number of line feeds per cell: Maximum of 253 linesĬolors in a workbook: Maximum of 16 million colors (32 bit with full access to 24 bit color spectrum) Number of characters that a cell can contain: Maximum of 32,767 charactersĬharacters in a header or footer: Maximum of 255 characters Page breaks: Maximum of 1,026 horizontal and vertical Linked sheets: Limited by available memory Zoom range: Maximum of 400 percent (minimum is 10 percent) Named views in a workbook: Limited by available memory Windows in a workbook: Limited by available memory Names in a workbook: Limited by available memory Sheets in a workbook: Limited by available memory (default is 1 sheet) Open workbooks: Limited by available memory and system resources Worksheet size: Maximum of 1,048,576 rows and 16,384 columns Excel Worksheet and Workbook Maximum Limits and Specifications
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |