XL2000: Limit of Natural Language Formulas per Worksheet (211522)
The information in this article applies to:
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
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCESFor additional information, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
222170 XL2000: Natural Language Formulas Produce #NAME? Errors
199411 XL2000: Natural Language Formulas Return Error
| Modification Type: | Major | Last Reviewed: | 10/8/2003 |
|---|
| Keywords: | kbbug kbpending KB211522 |
|---|
|