XL2000: Limit of Natural Language Formulas per Worksheet

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.

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.

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

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

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base: