Fix Excel Name Manager Freezing or Not Opening in Microsoft 365
Question details
The Name Manager stops responding or fails to open when accessed from the Formulas tab.
- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Attempting to view, edit, or delete defined names in specific worksheets or across various workbooks.
- Observed behavior
- The Excel application completely freezes, hangs, or the Name Manager dialog box refuses to open.
Before proceeding, manually save any open workbooks to prevent data loss in case Excel needs to be forcibly closed.
Run Excel in Safe Mode and Disable Add-ins
Running Excel in Safe Mode bypasses extensions and add-ins, helping you identify if a third-party plugin is causing the Name Manager to freeze.
Many freezing issues in Microsoft 365 are caused by outdated or conflicting COM add-ins. Starting Excel in Safe Mode loads the application without these extensions.
Press the Windows key + R to open the Run dialog. Type 'excel /safe' and press Enter. Excel will open with 'Safe Mode' displayed in the title bar.
Open the problematic workbook and go to Formulas > Name Manager. If it opens without freezing, an add-in is likely the culprit.
Go to File > Options > Add-ins. In the Manage drop-down box at the bottom, select 'COM Add-ins' and click Go. Uncheck all add-ins and click OK. Restart Excel normally and enable them one by one to find the conflicting add-in.
Repair Microsoft 365 Installation
A built-in Office repair can fix corrupted installation files that prevent core features like the Name Manager from functioning properly.
Update Excel to the Latest Build
Microsoft frequently releases patches for known bugs in Microsoft 365. Updating to the latest build can resolve random app freezes.
Experience Smooth Spreadsheet Management with WPS Office
If Microsoft Excel continues to freeze when managing named ranges and formulas, consider switching to WPS Office. It is a free, fast, and highly compatible alternative that avoids the heavy resource usage and bugs often found in Microsoft 365.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
- 2. Open Your Workbook: Launch WPS Spreadsheets, click File > Open, and select your existing Excel document.
- 3. Manage Named Ranges: Navigate to the Formulas tab and use the Name Manager smoothly without any freezing.
Frequently Asked Questions
Why does the Name Manager only freeze in specific worksheets?
This usually happens when a specific worksheet contains corrupted named ranges, broken external links pointing to network drives, or a massive amount of hidden names created by third-party systems. Cleaning up the workbook often resolves it.
Can I define a new name without opening the Name Manager?
Yes, you can quickly define a new name by selecting the cell or range and typing the desired name directly into the Name Box (located to the left of the Formula Bar), then pressing Enter. However, editing or deleting names still requires the Name Manager.
Will clearing my Excel cache fix the Name Manager freezing?
In some cases, yes. Corrupted temporary files can cause unpredictable behavior. You can clear the cache by navigating to File > Options > Save, scrolling down to Cache Settings, and clicking 'Delete cached files'.
