How to Fix Excel Freezing When Closing Files or Opening New Workbooks
Question details
Users experience Excel becoming unresponsive and freezing when attempting to close an existing file or open a new workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Trying to close an active spreadsheet or launch a new workbook for data entry.
- Observed behavior
- Microsoft Excel hangs, repeatedly displays a "Not Responding" error, and fails to close normally or open new files despite previous reinstalls.
Before proceeding with the troubleshooting steps, ensure you have saved your work in any other responsive Office applications and check your internet connection in case you need to download updates or repair tools.
Test Excel in Safe Mode and Disable Add-ins
Running Excel in Safe Mode prevents third-party add-ins from loading, allowing you to identify if a plugin is causing the freeze.
Conflicting or outdated COM add-ins are one of the most common reasons Excel freezes during basic operations like saving, closing, or opening files.
Press Windows + R on your keyboard to open the Run dialog box. Type 'excel /safe' and press Enter to launch Excel in Safe Mode.
Try opening a new workbook and then closing it. If Excel operates smoothly without freezing, an add-in is likely the culprit.
Click on File in the top-left corner, select Options, and then click on Add-ins in the left sidebar.
At the bottom of the window, ensure 'COM Add-ins' is selected in the Manage dropdown menu, then click Go. Uncheck all active add-ins and click OK.
Install Latest Updates and Check Service Health
Since software bugs in recent releases can cause application freezes, applying the latest patch is crucial.
Perform an Online Repair or Contact Support
If basic troubleshooting fails, you may need an advanced repair or direct diagnostic support from Microsoft.
Try WPS Office for a Stable, Crash-Free Experience
If Microsoft Excel continues to freeze and disrupt your workflow, switch to WPS Office. It is a highly stable, lightweight, and free alternative that opens, edits, and saves Microsoft Excel (.xlsx) files seamlessly without the frustrating bugs and freezing issues.
- 1. Download Installer: Visit the official WPS Office website and download the free installation package.
- 2. Quick Installation: Run the lightweight installer to quickly set up the office suite on your device in minutes.
- 3. Open Your Workbooks: Right-click your existing .xlsx or .xls files, select 'Open with', and choose WPS Spreadsheet to continue your work without freezing.
Frequently Asked Questions
Why does Excel suddenly say 'Not Responding' when I try to save or close?
This typically occurs due to conflicting third-party add-ins, corrupted local cache, or bugs introduced in a recent Microsoft 365 update. Running Excel in Safe Mode or running an Office repair can usually resolve these software conflicts.
Can a very large file size cause Excel to freeze when opening?
Yes. Workbooks with massive amounts of data, complex array formulas, external data connections, or excessive conditional formatting require significant system memory. This heavy load can cause Excel to temporarily hang or freeze during the opening process.
Will reinstalling Office fix the Excel freezing bug permanently?
Reinstalling can fix issues related to corrupted software files. However, if the freeze is caused by a documented bug in the latest Office release, reinstalling the exact same version may not fix it until Microsoft officially releases a patch update.
How do I recover my work if Excel freezes before I have a chance to save?
Force close Excel using the Windows Task Manager (Ctrl + Shift + Esc). When you reopen Excel, the Document Recovery pane should appear automatically on the left side, allowing you to restore the last auto-saved version of your workbook. To ensure this works in the future, verify that AutoRecover is enabled in File > Options > Save.
