Find and Fix #NAME? Errors in Your Excel Spreadsheet
#NAME? means Excel doesn't recognize something in your formula — a misspelled function, a deleted named range, or a missing add-in. Upload your file and we'll find every #NAME? error.
What Is a #NAME? Error?
#NAME? appears when Excel can't recognize a name used in a formula.
It's Excel saying: "I don't know what this word means." Unlike #REF!
(which means a cell is gone) or #VALUE! (which means wrong data type),
#NAME? specifically means the formula contains text that Excel can't
resolve to a function, named range, or other recognized element.
Common Causes
- Misspelled function names: VLOOKP instead of VLOOKUP, SUMIFS instead of SUMIF (or vice versa depending on argument count). Excel is case-insensitive for function names but completely literal about spelling. The formula bar autocomplete exists precisely because of how easy these typos are to make.
- Deleted or missing named ranges: A formula like
=SalesTotalwhere "SalesTotal" is a named range — if that named range is deleted, the formula shows#NAME?. These errors are particularly common in workbooks that have been trimmed or reorganized. - Text strings without quotes: Writing
=New Yorkinstead of="New York". Without quotes, Excel interprets "New" and "York" as two names it doesn't recognize. - Add-in functions when the add-in isn't loaded: Functions from Power Query,
Analysis ToolPak, or third-party add-ins show
#NAME?if the add-in isn't installed or enabled on the current machine. - Regional separator issues: In some locales, formula argument separators use
semicolons instead of commas. A formula using commas opened in a semicolon-separator locale
(or vice versa) can show
#NAME?if the parser gets confused.
The Named Range Audit
Named ranges are a common source of #NAME? errors that don't
appear in any cell formula. If a formula uses a named range that was later deleted — or if the
workbook was received from someone whose named ranges used different names — every formula
referencing that range shows #NAME?.
Our tool audits not just cell formulas but the Name Manager — identifying both broken named range references in formulas and orphaned defined names that exist in the workbook but are never referenced. Both are useful signals: broken references cause errors, while orphaned names may indicate stale configuration from an earlier version of the file.
When #NAME? Comes From Another Machine
A spreadsheet built on one machine with custom add-ins installed will show
#NAME? errors when opened on a machine without those add-ins.
Common culprits include Analysis ToolPak functions (though NETWORKDAYS and EOMONTH are now
built-in), Solver functions, and third-party statistical or financial packages. Our tool flags
these so you know which formulas require specific add-ins to function correctly.
This is a particularly common issue when sharing workbooks across organizations, or when files are moved from a workstation to a server or reporting environment where add-ins aren't available.
How to Fix #NAME? Errors
- For misspelled functions: Click the cell, correct the spelling in the formula bar. The formula bar autocomplete can help identify the correct spelling as you type.
- For missing named ranges: Use Formulas → Name Manager (Ctrl+F3) to check whether the name exists. If not, recreate it or update the formula to reference the cell directly.
- For unquoted text: Add quotation marks around the text string in the formula.
- For add-in functions: Ensure the required add-in is installed and enabled via File → Options → Add-ins → Manage Excel Add-ins.
- For errors hidden by IFERROR(): Temporarily remove the IFERROR wrapper to expose the underlying error, fix the root cause, then restore the IFERROR if appropriate.
Frequently Asked Questions
What causes #NAME? errors in Excel?
#NAME? occurs when Excel doesn't recognize a name in a formula. Common causes: misspelled function names, references to named ranges that have been deleted, text strings written without quotation marks, and functions from add-ins that aren't installed on the current machine.
Why does a formula show #NAME? on one computer but not another?
The most common reason is an add-in that's installed on one machine but not the other. Functions from add-ins (Analysis ToolPak, Power Query, third-party tools) show #NAME? when the add-in isn't loaded.
How do I find all named ranges in a workbook?
Go to Formulas → Name Manager (Ctrl+F3). This shows all defined names in the workbook, including their reference and scope. Our tool also audits named ranges for broken references and unused definitions.
Can #NAME? errors be hidden in nested formulas?
Yes, the same way other errors can — IFERROR() wraps the outer function and hides the inner #NAME? error. Our tool detects these even when they're not visible in the cell.