XL98: Maximum Array Size in Microsoft Excel 98Last reviewed: February 18, 1998Article ID: Q181285 |
The information in this article applies to:
SUMMARYThis article explains the limitations of arrays in Microsoft Excel 98 Macintosh Edition.
MORE INFORMATIONIn Microsoft Excel 98 Macintosh Edition, arrays in worksheets are limited by available random access memory and by the "entire column" rule.
Available MemoryUnlike earlier versions of Microsoft Excel, Microsoft Excel 98 Macintosh Edition does not impose a limit on the size of worksheet arrays; you are limited only by the amount of available memory on your computer. Because of this, you can create very large arrays that contain hundreds of thousands of cells.
The "Entire Column" RuleAlthough Microsoft Excel 98 Macintosh Edition allows you to create very large arrays, it does not allow you to create an array that uses an entire column or multiple columns of cells. This limitation is designed to prevent you from creating an array that uses an entire column of cells. Because recalculating an array formula that uses an entire column of cells is somewhat time consuming (65,536 cells per column), Microsoft Excel 98 Macintosh Edition does not allow you to create this kind of array in a formula.
Earlier Versions of Microsoft ExcelFor more information about the limits of worksheet arrays in earlier versions of Microsoft Excel, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q75376 TITLE : XL: Maximum Array Size in Microsoft Excel Array Formula ExamplesThe following is a list of array formula examples:
A1: =SUM(IF(B1:B65535=0,1,0)) A2: =SUM(IF(B:B=0,1,0)) A3: =SUM(IF(B1:J65535=0,1,0)) A4: =SUM(IF(B:J=0,1,0)) A5: =SUM(IF(B1:DD65535=0,1,0))NOTE: To use these examples, create a new workbook. Note that you must enter each formula as an array formula. To do this, type the formula in the formula bar, and then press COMMAND+RETURN to enter the formula and an array. The array formula results are as follows:
|
Additional query words: XL98
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |