This error occurs when Microsoft Excel does not recognize text in a formula.
Excel displays #NAME? in one or more cells on a worksheet.
- 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.
- Text may have been entered 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 calls a user-defined function (UDF) that is not available on your computer.
- Optionally, if error checking is turned on in Excel, click the button that appears next to the cell that displays the error , 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.
Make sure that a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) that you refer to in a formula does in fact exist by doing the following:
- Click the File tab, and then click Options.
- Click the Add-Ins category.
- In the Manage list box, click Excel Add-ins, and then click Go.
- In the Add-Ins available list, select the Euro Currency Tools check box, and then click OK.
- On the Formulas tab, in the Defined Names group, click Name Manager.
- In the Name Manager dialog box, verify that the name is listed.
- 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:
- Select the cell that contains the formula that you want to check for misspelled names.
- 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.) , select the misspelled name in the formula, and then press F3.
- 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:
- Select the cell that contains the formula containing the misspelled function.
- 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.) , select the misspelled function name.
- 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.
- 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).