'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Name Manager Not Opening or Out of Memory Error
Question details
The user is unable to open the Name Manager in Excel and encounters an Out of Memory error when trying to delete defined names using a macro.
- Product
- Microsoft Excel 2013
- Device & OS
- not provided
- Scenario
- Attempting to manage or delete defined names in a very large workbook containing hundreds of worksheets.
- Observed behavior
- The Name Manager interface fails to open after the loading progress indicator finishes, and VBA macros designed to clear names return a Run-time error 7 (Out of Memory).
Ensure your computer has sufficient physical memory (RAM) available and save a backup copy of your large workbook before attempting any troubleshooting steps or running VBA macros.
Troubleshoot Excel Display Settings and Safe Mode
Determine if hardware acceleration or a third-party add-in is causing the Name Manager to freeze or fail to display.
Often, UI glitches in older versions of Excel prevent dialog boxes like the Name Manager from properly rendering on the screen. Booting into Safe Mode safely bypasses add-ins, while disabling hardware acceleration fixes rendering conflicts.
Press Ctrl + F3 on your keyboard while the workbook is open to see if the Name Manager shortcut forces the dialog box to open.
Press Win + R to open the Run dialog box, type 'excel /safe', and press Enter. Once Excel opens, load your workbook and attempt to open the Name Manager again.
Go to File > Options > Advanced. Scroll down to the 'Display' section and check the box for 'Disable hardware graphics acceleration'.
Click OK to save your settings, close Excel completely, and reopen your workbook normally to test the Name Manager.
Repair the Microsoft Office Installation
Fix corrupted Office program files that might be preventing the Name Manager from functioning properly.
Delete Defined Names Using a Phased VBA Macro
Avoid Out of Memory errors in extremely large workbooks by deleting names in smaller, controlled batches.
Manage Large Spreadsheets Effortlessly with WPS Office
If Microsoft Excel continues to crash or display memory errors when handling heavy workbooks with hundreds of sheets, consider trying WPS Office. It is a highly optimized, lightweight alternative that parses massive datasets and manages defined names efficiently without bogging down your system memory.
- 1. Download and Install: Visit the official WPS website to download and install the free, lightweight suite.
- 2. Open Your Heavy Workbook: Launch WPS Spreadsheet and open your .xlsx file. WPS is designed to load files with hundreds of sheets smoothly.
- 3. Access the Name Manager: Navigate to the Formulas tab on the ribbon and click 'Name Manager' to securely view, edit, or delete your defined names.
Frequently Asked Questions
Why does Excel throw an 'Out of Memory' error when using a macro to delete names?
This typically happens in very large workbooks with thousands of defined names or phantom links. Excel attempts to process all the deletions in a single memory stack, exhausting available RAM. Deleting names in smaller batches can resolve this issue.
Can corrupted defined names cause the Name Manager to freeze?
Yes. If a workbook contains hundreds of hidden, broken, or corrupted defined names—often generated by duplicating sheets across different files—the Name Manager may fail to render the list, causing Excel to freeze or simply refuse to open the window.
How do I find hidden defined names that are slowing down my workbook?
Hidden names are not visible in the standard Name Manager dialog box. You must use a VBA script to change their 'Visible' property to 'True' before you can view and systematically delete them in the Name Manager interface.
Does hardware graphics acceleration affect Excel's Name Manager?
In some versions of Excel, particularly Excel 2013 and 2016, rendering the Name Manager UI can conflict with older graphics card drivers. Disabling hardware acceleration in the Advanced Options forces Excel to use software rendering, bypassing these display glitches.
