{"id":1580,"date":"2020-02-13T08:04:13","date_gmt":"2020-02-13T14:04:13","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1580"},"modified":"2025-06-30T21:44:12","modified_gmt":"2025-06-30T21:44:12","slug":"excel-limits","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1580","title":{"rendered":"Excel Limits"},"content":{"rendered":"\n

Worksheet and workbook specifications and limits<\/strong><\/p>\n\n\n\n

For more limits of VBA inside Excel, check out http:\/\/BoldCodes.com\/?DevID=26CFPFO4LB<\/a><\/p>\n\n\n\n

\n Feature <\/strong>\n <\/td>\n Maximum limit <\/strong>\n <\/td><\/tr>
\n Open workbooks\n <\/td>\n Limited by\n available memory and system resources\n <\/td><\/tr>
\n Worksheet size\n <\/td>\n 1,048,576 rows by\n 16,384 columns\n <\/td><\/tr>
\n Column width\n <\/td>\n 255 characters\n <\/td><\/tr>
\n Row height\n <\/td>\n 409 points\n <\/td><\/tr>
\n Page breaks\n <\/td>\n 1,026 horizontal\n and vertical\n <\/td><\/tr>
\n Total number of\n characters that a cell can contain\n <\/td>\n 32,767 characters\n <\/td><\/tr>
\n Sheet name length\n <\/td>\n 31 characters\n <\/td><\/tr>
\n Characters in a\n header or footer\n <\/td>\n 255\n <\/td><\/tr>
\n Sheets in a\n workbook\n <\/td>\n Limited by\n available memory (default is 3 sheets)\n <\/td><\/tr>
\n Colors in a\n workbook\n <\/td>\n 16 million colors\n (32 bit with full access to 24 bit color spectrum)\n <\/td><\/tr>
\n Named views in a\n workbook\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Unique cell\n formats\/cell styles\n <\/td>\n 64,000\n <\/td><\/tr>
\n Fill styles\n <\/td>\n 256\n <\/td><\/tr>
\n Line weight and\n styles\n <\/td>\n 256\n <\/td><\/tr>
\n Unique font types\n <\/td>\n 1,024 global fonts\n available for use; 512 per workbook\n <\/td><\/tr>
\n Number formats in\n a workbook\n <\/td>\n Between 200 and\n 250, depending on the language version of Excel that you have installed\n <\/td><\/tr>
\n Names in a\n workbook\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Windows in a\n workbook\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Hyperlinks in a\n worksheet\n <\/td>\n 66,530 hyperlinks\n <\/td><\/tr>
\n Panes in a window\n <\/td>\n 4\n <\/td><\/tr>
\n Linked sheets\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Scenarios\n <\/td>\n Limited by\n available memory; a summary report shows only the first 251 scenarios\n <\/td><\/tr>
\n Changing cells in\n a scenario\n <\/td>\n 32\n <\/td><\/tr>
\n Adjustable cells\n in Solver\n <\/td>\n 200\n <\/td><\/tr>
\n Custom functions\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Zoom range\n <\/td>\n 10 percent to 400\n percent\n <\/td><\/tr>
\n Reports\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Sort references\n <\/td>\n 64 in a single\n sort; unlimited when using sequential sorts\n <\/td><\/tr>
\n Undo levels\n <\/td>\n 100\n <\/td><\/tr>
\n Fields in a data\n form\n <\/td>\n 32\n <\/td><\/tr>
\n Workbook\n parameters\n <\/td>\n 255 parameters per\n workbook\n <\/td><\/tr>
\n Items displayed in\n filter drop-down lists\n <\/td>\n 10,000\n <\/td><\/tr>
\n Noncontiguous\n cells that can be selected\n <\/td>\n 2,147,483,648\n cells\n <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Calculation specifications and limits<\/strong><\/p>\n\n\n\n

\n Feature <\/strong>\n <\/td>\n Maximum limit <\/strong>\n <\/td><\/tr>
CountIF Criteria<\/td>256 characters<\/td><\/tr>
\n Number precision\n <\/td>\n 15 digits\n <\/td><\/tr>
\n Smallest allowed\n negative number\n <\/td>\n -2.2251E-308\n <\/td><\/tr>
\n Smallest allowed\n positive number\n <\/td>\n 2.2251E-308\n <\/td><\/tr>
\n Largest allowed\n positive number\n <\/td>\n 9.99999999999999E+307\n <\/td><\/tr>
\n Largest allowed\n negative number\n <\/td>\n -9.99999999999999E+307\n <\/td><\/tr>
\n Largest allowed\n positive number via formula\n <\/td>\n 1.7976931348623158e+308\n <\/td><\/tr>
\n Largest allowed\n negative number via formula\n <\/td>\n -1.7976931348623158e+308\n <\/td><\/tr>
\n Length of formula\n contents\n <\/td>\n 8,192 characters\n <\/td><\/tr>
\n Internal length of\n formula\n <\/td>\n 16,384 bytes\n <\/td><\/tr>
\n Iterations\n <\/td>\n 32,767\n <\/td><\/tr>
\n Worksheet arrays\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Selected ranges\n <\/td>\n 2,048\n <\/td><\/tr>
\n Arguments in a\n function\n <\/td>\n 255\n <\/td><\/tr>
\n Nested levels of\n functions\n <\/td>\n 64\n <\/td><\/tr>
\n User defined\n function categories\n <\/td>\n 255\n <\/td><\/tr>
\n Number of\n available worksheet functions\n <\/td>\n 341\n <\/td><\/tr>
\n Size of the\n operand stack\n <\/td>\n 1,024\n <\/td><\/tr>
\n Cross-worksheet\n dependency\n <\/td>\n 64,000 worksheets\n that can refer to other sheets\n <\/td><\/tr>
\n Cross-worksheet\n array formula dependency\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Area dependency\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Area dependency\n per worksheet\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Dependency on a\n single cell\n <\/td>\n 4 billion formulas\n that can depend on a single cell\n <\/td><\/tr>
\n Linked cell\n content length from closed workbooks\n <\/td>\n 32,767\n <\/td><\/tr>
\n Earliest date\n allowed for calculation\n <\/td>\n January 1, 1900\n (January 1, 1904, if 1904 date system is used)\n <\/td><\/tr>
\n Latest date\n allowed for calculation\n <\/td>\n December 31, 9999\n <\/td><\/tr>
\n Largest amount of\n time that can be entered\n <\/td>\n 9999:59:59\n <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Charting specifications and limits<\/strong><\/p>\n\n\n\n

\n Feature <\/strong>\n <\/td>\n Maximum limit <\/strong>\n <\/td><\/tr>
\n Charts linked to a\n worksheet\n <\/td>\n Limited by\n available memory \n <\/td><\/tr>
\n Worksheets\n referred to by a chart\n <\/td>\n 255\n <\/td><\/tr>
\n Data series in one\n chart\n <\/td>\n 255\n <\/td><\/tr>
\n Data points in a\n data series for 2-D charts\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Data points in a\n data series for 3-D charts\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Data points for\n all data series in one chart\n <\/td>\n Limited by\n available memory\n <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

PivotTable and PivotChart report specifications and\nlimits<\/strong><\/p>\n\n\n\n

\n Feature <\/strong>\n <\/td>\n Maximum limit <\/strong>\n <\/td><\/tr>
\n PivotTable reports\n on a sheet\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Unique items per\n field\n <\/td>\n 1,048,576\n <\/td><\/tr>
\n Row or column\n fields in a PivotTable report\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Report filters in\n a PivotTable report\n <\/td>\n 256 (may be\n limited by available memory)\n <\/td><\/tr>
\n Value fields in a\n PivotTable report\n <\/td>\n 256\n <\/td><\/tr>
\n Calculated item\n formulas in a PivotTable report\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Report filters in\n a PivotChart report\n <\/td>\n 256 (may be\n limited by available memory)\n <\/td><\/tr>
\n Value fields in a\n PivotChart report\n <\/td>\n 256\n <\/td><\/tr>
\n Calculated item\n formulas in a PivotChart report\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Length of the MDX\n name for a PivotTable item \n <\/td>\n 32,767\n <\/td><\/tr>
\n Length for a\n relational PivotTable string\n <\/td>\n 32,767\n <\/td><\/tr>
\n Items displayed in\n filter drop-down lists\n <\/td>\n 10,000\n <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Shared workbook specifications and limits<\/strong><\/p>\n\n\n\n

\n Feature <\/strong>\n <\/td>\n Maximum limit <\/strong>\n <\/td><\/tr>
\n Users who can open\n and share a shared workbook at the same time\n <\/td>\n 256\n <\/td><\/tr>
\n Personal views in\n a shared workbook\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Days that change\n history is maintained\n <\/td>\n 32,767 (default is\n 30 days)\n <\/td><\/tr>
\n Workbooks that can\n be merged at one time\n <\/td>\n Limited by\n available memory\n <\/td><\/tr>
\n Cells that can be\n highlighted in a shared workbook\n <\/td>\n 32,767\n <\/td><\/tr>
\n Colors used to\n identify changes made by different users when change highlighting is turned\n on\n <\/td>\n 32 (each user is\n identified by a separate color; changes made by the current user are\n highlighted with navy blue)\n <\/td><\/tr>
\n Excel tables in a\n shared workbook\n <\/td>\n 0 (zero) \n Note:<\/strong> A workbook that contains one or\n more Excel tables cannot be shared.\n <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

From https:\/\/support.office.com\/en-us\/article\/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?ui=en-US&rs=en-US&ad=US&fromAR=1<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Worksheet and workbook specifications and limits For more limits of VBA inside Excel, check out http:\/\/BoldCodes.com\/?DevID=26CFPFO4LB Feature Maximum limit Open workbooks Limited by available memory and system resources 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…<\/p>\n

Read More “Excel Limits”<\/span> »<\/a><\/p>\n","protected":false},"author":1,"featured_media":1581,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,5,12],"tags":[129,156,190],"class_list":["post-1580","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-user-tips","category-non-functions","category-worksheet","tag-excel","tag-limits","tag-stop"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1580"}],"version-history":[{"count":1,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1580\/revisions"}],"predecessor-version":[{"id":1922,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1580\/revisions\/1922"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1581"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}