Article ID: 211851 - View products that this article applies to.
This article was previously published under Q211851
This article has been archived. It is offered "as is" and will no longer be updated.
When you use a natural language formula to reference cells, you receive a #NAME? error message.
This problem occurs when the data the formula refers to is returned from either of the following:
If a formula that uses a natural language reference returns a #NAME? error message after you update data from an external database, do the following to recalculate the formula:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
When you use natural language formulas, it is not necessary to create defined names or determine the cell ranges in advance. Microsoft Excel 2000 determines the range based on the row and column labels that you provide in the table on your worksheet.
You can link data to a Microsoft Excel workbook in the following ways:
ExampleTo set up an example that demonstrates the problem, type the following data in a worksheet:
In this example, the following formula returns the value 240 for the sum of quarters 1 and 2 for the West region:
A1: B1: Quarter1 C1: Quarter2 A2: North B2: 100 C2: 120 A3: West B3: 110 C3: 130 A4: East B4: 120 C4: 140 A5: South B6: 130 C5: 150
= Sum(West)However, if your data is linked or from an external data source and you update the data, the formula returns the #NAME? error message.
For more information about labels and names in formulas, click Microsoft Help on the Help menu, type name cells in a workbook in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For additional information about natural language formulas, click the article number below to view the article in the Microsoft Knowledge Base:
279412For additional information about how to enable natural language formulas, click the article number below to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/279412/EN-US/ )XL2000: How to Use Natural Language Formulas
(https://support.microsoft.com/kb/222170/EN-US/ )XL2000: Natural Language Formulas Produce #NAME? Errors