The information in this article applies to:
SYMPTOMSWhen you use a natural language formula to reference cells, the result is a #NAME? error. CAUSEThis problem occurs when the data the formula refers to is returned from either of the following:
-or- WORKAROUNDIf a formula that uses a natural language reference returns a #NAME? error after you update data from an external database, do the following to recalculate the formula:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
When you use natural language formulas, it is not necessary to create
defined names or determine the cell ranges in advance. Microsoft Excel 97
determines the range based on the row and column labels that you provide
in the table on your worksheet.
Q141227 Using External Data with Microsoft Excel 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:
However, if your data is linked or from an external data source and you
update the data, the formula returns #NAME?.
For additional information about using natural language formulas, please
see the following article in the Microsoft Knowledge Base:
Q161881 XL97: How to Use Natural Language Formulas REFERENCESFor more information about natural language formulas, click the Index tab in Help, type the following text labels, in formulasand then double-click the selected text to go to the "Learn about labels and names in formulas" topic. Additional query words: 97 XL97 calc recalc calculate update Refreshing
Keywords : xlformula |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |