XL7: Formula Returns #NAME? Error with AutoCorrect Enabled

Last reviewed: March 27, 1997
Article ID: Q133140
7.00 WINDOWS kbusage kbtool

The information in this article applies to:

  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

When the AutoCorrect feature of Microsoft Excel is enabled, words listed in the AutoCorrect List (ACL) will change/correct spellings of words used in formulas. This behavior may mean that the "#NAME!" error messages is displayed in cells with formulas, because "corrected" defined names do not exist on the worksheet.

CAUSE

Because AutoCorrect looks at the contents of cells to determine which word needs to be changed, AutoCorrect will replace misspelled defined name ranges; this replacement may cause the #NAME! error value to be displayed in the cell.

WORKAROUND

To work around this problem, use any of the following methods.

Method 1: Disable AutoCorrect before you enter formulas that contain names

          that are flagged as misspelled in the AutoCorrect List. To
          disable AutoCorrect, click AutoCorrect on the Tools menu and
          clear the "Replace Text As You Type" option.

Method 2: Remove the particular word from the AutoCorrect List before you
          enter the formula. To remove the word from the AutoCorrect List,
          choose AutoCorrect from the Tools menu, select the name from the
          list, and choose the Delete button.

Method 3: Use the INDIRECT() function to keep the preferred spelling. For
          example, if the misspelled word is "teh," use this:

             =INDIRECT("teh")

Method 4: If the formulas are already entered on the worksheet and you need
          to change them to use the original name, use the Replace feature.

          a. On the Edit menu, click Replace.

          b. In the Find What box, type the word you are trying to replace
             (for example "The").

          c. In the Replace With box, type the misspelled version of the
             word (for example, "Teh").

          d. Click Find Next to locate the cell that contains the word you
             want to modify, and choose the Replace button.

REFERENCES

For more information about the INDIRECT Worksheet Function, choose the Index button in Help and type:

   INDIRECT


KBCategory: kbusage kbtool
KBSubcategory: xlwin

Additional reference words: 7.00 auto correct automatically revert
Keywords : xlwin kbtool kbusage
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.