Microsoft KB Archive/211522

= XL2000: Limit of Natural Language Formulas per Worksheet =

Article ID: 211522

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211522





SYMPTOMS
In Microsoft Excel 2000, when you enter a formula in a cell, the formula may disappear unexpectedly, leaving the cell empty. You do not receive an error message.

Also, when you attempt to add a large number of natural language formulas all at once (for example, by filling a formula down through a large number of cells), Excel may stop responding.



CAUSE
The problems may occur if both of the following conditions are true:  You are using natural language formulas, for example

=RowName ColName

where RowName and ColName are labels on a table of information within the worksheet.

-and- The worksheet contains a very large number of formulas of this type.

In Excel 2000, a worksheet can contain up to 65,529 natural language formulas. If you exceed this limit, the problems described in this article may occur.



WORKAROUND
To work around this problem, remove some of the existing natural language formulas from the worksheet before you add any new ones.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

