Microsoft KB Archive/256567

= XL2000: Cannot Enter More Than 65,472 Array Formulas in a Worksheet =

Article ID: 256567

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q256567



SYMPTOMS
In Microsoft Excel 2000, if you fill or copy a very large number of array formulas in a worksheet, the array formulas may no longer appear after a certain point in the worksheet.



CAUSE
This behavior can occur if the worksheet contains more than 65,472 array formulas that refer to another worksheet.



RESOLUTION
In Excel 2000, a single worksheet may contain a maximum of 65,472 array formulas that refer to another worksheet. If you want to use more formulas, split the data into multiple worksheets so that there are fewer than 65,472 references to a single worksheet.

For example, in Sheet1 of a workbook, you can create the following:
 * 65,472 array formulas that refer to Sheet2
 * 65,472 array formulas that refer to Sheet3
 * 65,472 array formulas that refer to Sheet4

If you attempt to create more than 65,472 array formulas that refer to a specific worksheet, the array formulas that you enter after array-formula number 65,472 formula may disappear when you enter them.

Additional query words: 32700 sr1 XL2000

Keywords: kberrmsg kbprb kbpending KB256567

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.