Microsoft KB Archive/222170

= XL2000: Natural Language Formulas Produce #NAME? Errors =

Article ID: 222170

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q222170



SYMPTOMS
When you use a natural language formula you receive a #NAME? error.



CAUSE
This occurs when natural language formulas are not enabled.



RESOLUTION
To resolve this issue, enable natural language formulas. To do this, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) In the Options dialog box, click the Calculation tab.
 * 3) Under Workbook options, click to select the Accept labels in formulas check box.



MORE INFORMATION
Natural language formulas are disabled by default. This behavior is different from earlier versions of Microsoft Excel. To enable natural language formulas as the default behavior, follow these steps:

 On the Tools menu, click Options. In the Options dialog box, click the Calculation tab. Under Workbook options, click to select the Accept labels in formulas check box. Click OK. On the File menu, click Save As. Name the file "book.xlt" (without the quotation marks). In the Save as type list, click Template.  In the Save in list, click the appropriate folder for your operating system.

Windows 95/98
C:\Windows\Application Data\Microsoft\Excel\XLStart

Windows NT
C:\Winnt\Profiles\ \Application Data\Microsoft\Excel\XLStart

where  represents your user name.

Windows 2000
C:\Documents and Settings\ \Application Data\Microsoft\Excel\XLStart

where  represents your user name. </li> Click Save.</li></ol>

Additional query words: XL2000

Keywords: kbprb KB222170

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.