Excel Unique Name Error: Why It Appears and How to Fix It

If Excel says a name is already taken or must be unique, the name you are trying to assign conflicts with an existing workbook object—most often a defined name, an Excel table, or a worksheet. Check which kind of object you are renaming, locate the existing name in that object’s list, then choose a distinct name or rename the conflict; the exact fix depends on where the message appears.

What the unique-name message means

Excel uses names to identify things in a workbook, including worksheets, tables, and named ranges. Each kind of object follows its own naming rules and has its own scope. A message about a name being unavailable is therefore not necessarily a problem with the text itself: Excel may be telling you that another object of the same kind already uses it.

The wording varies with the action and Excel version. You might see a prompt such as “That name is already taken. Try a different one,” or a message saying a name already exists. The location of the message is a useful clue. If you see it while editing a table name, look for another table; if it appears while renaming a sheet, check the sheet tabs; if it appears in the Name Manager, look at defined names.

Names are generally not case-sensitive. For example, Excel treats SalesData and salesdata as the same name in contexts where names must be unique. Changing only capitalization will not resolve a duplicate.

Which Excel names can conflict?

Three kinds of names commonly cause confusion because they are all edited in different places:

Defined names refer to a cell, range, constant, or formula. For example, a workbook might have a name such as TaxRate referring to a cell that contains a rate.
Table names identify Excel tables, which are structured data ranges with filter buttons and structured references. Excel might name a table Table1 automatically.
Worksheet names appear on the sheet tabs, such as January or Forecast 2026.

These are separate naming systems. A worksheet and a defined name can sometimes have the same text because they are different object types, while two tables in one workbook cannot share a table name. Worksheet names must be unique among the sheets in that workbook. Defined names have scope rules: a workbook-scoped name is available throughout the workbook, while a sheet-scoped name belongs to one worksheet. A local name can also coexist with a workbook-level name of the same spelling, though that can make formulas harder to interpret because the sheet-level name takes precedence on its sheet.

Find the name that is already in use

Start with the part of Excel where the warning appeared. If you are unsure, inspect the Name Manager and table names, then check the sheet tabs. Avoid deleting a name just because it looks unfamiliar: formulas, charts, or other workbook features may depend on it.

For defined names: select Formulas > Name Manager. Review the Name and Scope columns and look for the spelling Excel rejected. Select a name to see its reference in the Refers to field.
For tables: click inside a table. Open the contextual Table Design tab and read the Table Name box, usually at the left of the ribbon. Check other tables in the workbook for the same name.
For worksheets: review the sheet tabs, including tabs that may be hidden. A hidden sheet still exists and its name remains in use. To check hidden sheets, right-click a sheet tab and select Unhide if that command is available.

If a workbook came from another person, a template, or an older spreadsheet, it may contain names that are not obvious from the visible cells. In Name Manager, inspect the scope and reference of any plausible match before changing it. A name can refer to a formula or constant rather than a visible range.

Fix a duplicate defined name

In Excel for Microsoft 365 on Windows, go to Formulas > Name Manager, select the conflicting defined name, and choose Edit to give it a new spelling. If the old name is genuinely unused and unnecessary, you can select it and choose Delete instead. Save a copy before deleting names from an important workbook, and check formulas that may use the name.

When creating a new name, use Formulas > Define Name or the New button in Name Manager. The Scope setting matters: choose Workbook for a name intended to be available across sheets, or select a particular sheet for a sheet-scoped name. If a name already exists within the scope you select, use a different name or edit the existing definition rather than creating a duplicate.

Do not assume that two names with the same spelling are harmless because they point to the same cells. If one is sheet-scoped and another workbook-scoped, formulas on that sheet can resolve to the local definition instead of the workbook-level one. This can produce results that differ from formulas on other sheets. If both definitions are needed, document their scopes clearly; otherwise, consider renaming one to make the distinction obvious.

Fix a duplicate table name

Click inside the table, open Table Design, and change the text in the Table Name box. Press Enter to apply the new name. Table names must be unique across the workbook, even when the tables are on different worksheets. A name that is already used by a table elsewhere cannot be reused just because the other table is on a different sheet.

Table names are useful in formulas because they make structured references readable. For instance, a formula can refer to a table column by its table and column names rather than by a fixed range address. Renaming a table may update its structured references, but it is still sensible to review important formulas, charts, queries, or external connections after a rename. Give tables descriptive names such as Orders2026 or ProductList, rather than relying on generic names like Table1.

Fix a duplicate worksheet name

To rename a worksheet in Windows, double-click its tab, type a different name, and press Enter. You can also use Home > Format > Rename Sheet. Choose a name not already assigned to another sheet in that workbook. Sheet names can contain spaces, unlike defined names and table names, so a label such as Quarterly Summary is valid.

Hidden sheets count too. If you cannot find a visible tab with the name, right-click a sheet tab and choose Unhide to see whether a hidden worksheet is using it. If Unhide is unavailable, there may be no ordinarily hidden sheet to show; a sheet protected as “very hidden” through VBA is a different case and is not normally exposed by the standard Unhide dialog. Workbook structure protection can also prevent sheet changes, but that is a separate restriction from a duplicate-name error.

On Excel for Mac, the same basic objects and naming rules apply, although ribbon labels and dialog layouts can differ slightly by release. In Excel for the web, some workbook-management controls are more limited than in the desktop app; if you cannot find or edit the relevant name there, open the workbook in desktop Excel.

Rules for choosing a valid name

A name can be unique and still be invalid. Defined names and table names have stricter rules than worksheet labels. For a defined name or table name, use a short, descriptive label without spaces; underscores can separate words. Excel does not distinguish uppercase from lowercase when checking whether names conflict.

Start a defined name with a letter, underscore, or backslash; do not start it with a number.
Use letters, numbers, periods, and underscores for a practical, compatible name. Spaces are not allowed in defined names or table names.
Do not use a spelling that Excel could interpret as a cell reference, such as A1.
Do not use a name that is already assigned within the relevant object type and scope.
Keep names descriptive and consistent, such as CustomerList or NetSales.

Worksheet labels have different rules: they can contain spaces, but cannot contain certain characters such as a colon, backslash, slash, question mark, asterisk, or square brackets, and they are limited to 31 characters. If Excel rejects a sheet label, it may be due to one of these restrictions rather than a duplicate. The prompt and the object being edited help distinguish the two cases.

Do not confuse it with a #NAME? formula error

A unique-name warning is not the same as the worksheet error #NAME?. The latter usually means Excel cannot recognize text in a formula as a valid function or defined name. Common causes include a misspelled function, an undefined name, or text in a formula that needs quotation marks. For example, if a formula refers to Revenue but no defined name called Revenue exists, Excel may return #NAME?.

Creating a name with the same spelling as an existing name does not repair every #NAME? error. First inspect the formula and confirm whether the intended name exists and points to the right cells. Conversely, if Excel refuses a new table or sheet name, changing a formula will not fix that collision; rename the object that is already using the requested label.

Prevent name conflicts in shared workbooks

A few naming habits make future errors less likely, particularly when several people build sheets, tables, and formulas in the same file. Agree on a simple convention before a workbook grows, and avoid generic names that are easy to reuse accidentally.

Use prefixes to show purpose, such as rng_ for a defined range or tbl_ for a table, if that convention suits your team.
Check Name Manager before adding names to a workbook that already contains formulas or imported data.
Give each table a meaningful, distinctive name as soon as it is created.
When copying sheets between workbooks, review defined names and formulas afterward; copied content can bring names or references with it.
Before removing a name, check its Refers to entry and search important formulas for its use.

Consistent naming is not just cosmetic. It helps someone understand a formula, reduces accidental references to the wrong scoped name, and makes it easier to maintain a workbook after the original author is no longer editing it.

Frequently Asked Questions

Why does Excel say a name already exists when I cannot see it?
A defined name may be listed in Name Manager without appearing as text in a cell, and a worksheet using the name may be hidden. Check Formulas > Name Manager, the table names, and hidden sheet tabs. Confirm the object type before deleting or renaming anything.

Can two Excel sheets have the same name?
No. Worksheet names must be unique within a workbook, including names assigned to hidden sheets. You can use the same label for a different type of object in some circumstances, because sheets, tables, and defined names are separate categories.

Can two defined names have the same spelling?
They can coexist in some cases if one is workbook-scoped and the other is scoped to a particular worksheet. They cannot be treated as interchangeable: the local name takes precedence on its sheet. Use distinct names unless you deliberately need that scope behavior.

Why can I not reuse a table name on another sheet?
Excel requires table names to be unique across the entire workbook, not just on the sheet where each table sits. Rename one of the tables from its Table Design tab.

Does changing uppercase or lowercase make a name unique?
No. Excel name comparisons are not case-sensitive, so Sales and SALES are considered the same spelling for uniqueness checks. Add or change letters, numbers, or underscores instead.

Is #NAME? the same as a unique-name error?
No. #NAME? appears in a formula cell when Excel cannot resolve part of a formula, while a unique-name warning appears during an attempt to assign an object a name that conflicts or is invalid. Diagnose them separately.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.