Remove Duplicate or Old Defined Names in Excel with WPS Office
Question details
The user needs to remove duplicate or outdated defined names from an older Excel workbook when the Name Manager Delete command is unavailable, then verify formulas work correctly.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user is working with an older workbook that contains duplicate defined names, some referring to a previous file path, and needs to clean them safely.
- Observed behavior
- The Delete command in Name Manager is unavailable, so obsolete defined names cannot be removed through the normal interface.
Open the workbook in WPS Office Spreadsheets and click Formulas > Name Manager to list all defined names. Identify the sheet layouts and constant values you must keep before rebuilding the clean copy.
Rebuild a clean workbook with Paste Special to remove old defined names
Use this method when the Delete button in Name Manager is grayed out or unavailable, so obsolete names and external file-path references are not copied into the new workbook.
Standard copy and paste of entire sheets can carry defined names into the destination workbook. Paste Special lets you copy only the required layout, values, and formatting without importing the named references.
After rebuilding, recreate the defined names you still need and verify the formulas in the clean workbook.
In WPS Office Spreadsheets, open the affected workbook and click Formulas > Name Manager. Note the duplicate names and any names whose Refers To path points to a previous file path.
Press Ctrl+N, or click Menu > File > New > Blank workbook, to create the clean workbook that will receive the copied layout and constants.
In the original workbook, select the cell ranges or sheet areas you need to keep, press Ctrl+C, switch to the new workbook, then click Home > Paste > Paste Special and choose Values or Formulas with formatting. Do not use standard Paste for entire sheets if you need to avoid importing named references.
If you copied content into new sheets in the original workbook, delete the old sheets that still contain the obsolete names: right-click each sheet tab and choose Delete. Otherwise, keep the new workbook as the clean copy and archive the original.
In the clean workbook, click Formulas > Name Manager > New to recreate only the defined names you still need, set the correct Refers To range, then check that all formulas resolve to the intended cells.
Remove Old Defined Names in WPS Office Spreadsheets
WPS Office Spreadsheets gives you Name Manager and Paste Special tools to remove duplicate or obsolete Excel defined names and rebuild a clean workbook without losing your data.
- 1. Open your workbook: Launch WPS Office Spreadsheets and open the Excel workbook that contains the duplicate or old defined names.
- 2. Inspect names: Click Formulas > Name Manager to list all defined names and identify any Refers To paths pointing to a previous file.
- 3. Build a clean copy: Create a new workbook and use Home > Paste > Paste Special to copy only the required ranges, values, and formatting into new sheets.
- 4. Remove old sheets and names: Delete the sheets that contain the obsolete names, then use Formulas > Name Manager > New to recreate only valid defined names.
- 5. Save the workbook: Click Menu > Save As and choose Excel Workbook (.xlsx) to save the cleaned file.
Frequently Asked Questions
Why is the Delete button unavailable in Excel Name Manager?
It can be unavailable when the workbook is protected or shared, or when the name is built-in or created by an external link. If the normal Delete action is grayed out, rebuild the workbook with Paste Special to leave the old names behind.
Does Paste Special copy defined names to the new workbook?
When you use Home > Paste > Paste Special and choose Values or Formulas instead of standard Paste for entire sheets, defined names are not imported with the selected contents.
How do I recreate a defined name after cleanup?
Open Formulas > Name Manager and click New. Enter the name, set the Scope, and enter the correct Refers To range for the active sheet.
Can I remove all duplicate names at once?
In Name Manager, you can select multiple names and delete them if the Delete button is available. If it is unavailable, use the clean workbook method and recreate only the names you need.
Will this method work with Microsoft Excel files?
Yes, WPS Office Spreadsheets opens and saves .xlsx and .xls files. After cleanup, save as Excel Workbook to keep formulas and defined names compatible with Microsoft Excel.
