VBA & Macro Problems

How to Fix Excel Defined Names Reappearing After Deletion

Kushani Nimanthika Sep 25, 2026 871 views

Question details

The user is experiencing an issue where defined names in an Excel workbook are automatically recreated upon reopening, even after being manually deleted in the Name Manager.

How to Stop Excel Defined Names From Reappearing After Deletion

Product: Excel
Device & OS: not provided
Scenario: Managing workbook defined names and cleaning up hundreds or thousands of unwanted automated name ranges.
Observed behavior: Deleted defined names in the Name Manager automatically reappear when the workbook is saved, closed, and reopened.

Before you start

Before troubleshooting, create a backup copy of your Excel workbook to ensure your original data remains safe while testing macros, add-ins, and external links.

Solution 1Recommended

Identify the Source and Disable Recreating Automation

Find out if tables, PivotTables, external links, or macros are regenerating the names, and disable the source.

Deleting names from the Name Manager only removes the symptom, not the root cause. If the names return upon reopening, they are being dynamically generated by another component in the workbook.

Inspect Name Manager Details

Go to the 'Formulas' tab and click on 'Name Manager'. Review the 'Scope' and 'Refers To' columns to identify where the names are pointing, which often hints at their origin (e.g., a specific add-in or external workbook).

Check for Macros and Workbook Events

Press Alt + F11 to open the VBA Editor. Double-click 'ThisWorkbook' in the Project Explorer and look for 'Workbook_Open' events that might be scripted to recreate names. Check individual sheet modules as well.

Test with Add-ins Disabled

Go to File > Options > Add-ins. At the bottom, manage 'Excel Add-ins' and 'COM Add-ins' by clicking 'Go'. Uncheck active add-ins, save the workbook, delete the names, and reopen to see if an add-in was the culprit.

Identify the Source and Disable Recreating Automation

Table-Generated Names: Names generated by structured Excel Tables or PivotTables cannot be permanently deleted from the Name Manager. Excel requires these names for the tables to function. To remove them, the table must be converted to a normal range or deleted.

Manage Workbook Names Efficiently

Use WPS Spreadsheet to Manage Defined Names and Macros

WPS Office provides a clean, intuitive Name Manager and robust compatibility with Microsoft Excel files, allowing you to easily track down unwanted automated names, manage ranges, and handle macros without hassle.

1. Open your Workbook in WPS Spreadsheet: Launch WPS Office and open your .xlsx or .xlsm file.
2. Access the Name Manager: Navigate to the 'Formulas' tab on the top ribbon and click 'Name Manager'.
3. Review and Clean Up: Sort the names by 'Refers To' or 'Scope' to identify automated entries. Select the unwanted names and click 'Delete'.
4. Manage Macros: If names are script-generated, go to the 'Developer' tab, click 'Macros', and edit or disable the scripts causing the issue.

Advanced Name Manager to quickly identify broken references or hidden names.Full compatibility with Microsoft Excel (.xlsx, .xls) and macro-enabled formats (.xlsm).Lightweight and fast, even when handling workbooks with thousands of defined names.Built-in developer tools to troubleshoot external links and VBA scripts effectively.

microsoft office alternative - wps office

Frequently Asked Questions

Can hidden defined names cause this issue?

Yes, Excel workbooks can contain hidden defined names created by add-ins or macros that aren't visible in the standard Name Manager. You may need to run a small VBA script to unhide them (setting their Visible property to True) before they can be manually investigated and permanently deleted.

Why do names associated with PivotTables keep returning?

PivotTables automatically generate defined names in the background for their data ranges and cache to function properly. As long as the PivotTable exists in the workbook, Excel will continually recreate its associated name. You must delete the PivotTable if you want the name gone entirely.

How do external links affect defined names?

If your workbook contains links to another file that has defined names, Excel may pull those names into your current file's Name Manager. You must break the external links via Data > Edit Links > Break Link to stop the external workbook from feeding those names back into your file.

Excel & Data Problems