Excel: Maximum Number of Cells in an Array

Last reviewed: November 2, 1994
Article ID: Q49272
The information in this article applies to :
  • Microsoft Excel for the Macintosh, version 2.2 and 3.0

SUMMARY

In Microsoft Excel version 3.00, the maximum number of cells that can be included in an array is approximately 6400.

In Microsoft Excel version 2.20, the maximum number of cells that can be included in an array is 1636.

Exceeding this limit can cause a function that accepts arrays as arguments to return #NUM!, even though the function is syntactically correct.

In most cases, the formula can be rewritten so that it refers to a smaller subportion of the array, or the array can be broken into smaller portions.

MORE INFORMATION

Microsoft Excel for the Macintosh, versions 2.20 and 3.00 manipulate memory in 16K dynamically allocated blocks. Each array element generally takes 1 byte; thus, there is a limit of approximately 1600 units for each block. Excel 2.20 can use one block per array.

Excel 3.00 can use up to 64K for array elements.


KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20 2.2 3.00 3.0 publish subscribe


KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20 3.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.