Correct a #NAME? error

This error occurs when Microsoft Office Excel does not recognize text in a formula.

Symptom

Excel displays #NAME? in one or more cells on a worksheet.

Causes

  • The EUROCONVERT function is used in a formula, but the Euro Currency Tools add-in is not loaded.
  • A formula refers to a name (name: A word or string of characters in Excel that represents a cell, range of cells, formula, or constant value.) that does not exist.
  • A formula refers to a name that is not spelled correctly.
  • The name of a function that is used in a formula is not spelled correctly.
  • You may have entered text in a formula without enclosing it in double quotation marks.
  • A colon (:) was omitted in a range reference.
  • A reference to another sheet is not enclosed in single quotation marks (').
  • A workbook that you open calls a user-defined function (UDF) that is not available on your computer.

Resolution

  • Optionally, if error checking is turned on in Excel, click the button that appears next to the cell that displays the error Button image, click Show Calculation Steps if it appears, and then click the resolution that is appropriate for your data.

 Tip   Review the following resolutions to help determine which option to click.

Click the Microsoft Office Button Button image, click Excel Options, and then click the Add-ins category.

  1. In the Manage list box, click Excel Add-ins, and then click Go.
  2. In the Add-Ins available list, select the Euro Currency Tools check box, and then click OK.
  1. On the Formulas tab, in the Defined Names group, click Name Manager.
  2. In the Name Manager dialog box, verify that the name is listed.
  3. If the name is not listed, close the dialog box and then add the name by clicking Define Name in the Defined Names group.
  • Correct the spelling of a misspelled name that you referred to in a formula by doing the following:
  1. Select the cell that contains the formula that you want to check for misspelled names.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar, select the misspelled name in the formula, and then press F3.
  3. In the Paste name box, click the name that you want to use, and then click OK.
  • Insert the correct function name in the formula that results in the error by doing the following:
  1. Select the cell that contains the formula containing the misspelled function.
  2. In the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar, select the misspelled function name.
  3. In the Name Box (to the left of the formula bar), click the arrow and then select a function from the list that Excel suggests.

If you can't find the function that you want to use, click More Functions to see all available worksheet functions. Then locate the function that you want to use.

  1. In the Function Arguments dialog box, review the argument values and then click OK to complete the formula.
  • Enclose text in the formula in double quotation marks. For example, the following formula joins the text "The total amount is " with the value in cell B50:

="The total amount is "&B50

  • Make sure that all range references in the formula use a colon (:). For example, SUM(A1:C10).
  • If the formula refers to values or cells in other worksheets or workbooks, and the name of the other worksheet or workbook contains a nonalphabetical character or a space, you must enclose its name within single quotation marks ( ' ) in the formula.
  • When a user-defined function (UDF) that is not available on your computer is called from a workbook that you open, you (or a developer) can implement a UDF in several ways. For more information, see Visual Basic Help and the Microsoft Office SharePoint Server 2007 Software Development Kit (SDK).
 
 
Applies to:
Excel 2007