'%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 Crashing or Becoming Unresponsive When Closing
Question details
The user is experiencing an issue where Microsoft Excel crashes, freezes, or becomes completely unresponsive specifically when attempting to close the application.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Closing the Excel application after working normally.
- Observed behavior
- The application stops responding or crashes during the shutdown process, requiring a forced exit. However, the issue does not occur when Excel is run in Safe Mode.
Ensure you have saved all active workbooks manually to prevent data loss, and verify that your Windows operating system is fully updated before attempting to repair Office.
Disable COM Add-ins in Excel
Since the issue doesn't occur in Safe Mode, a third-party add-in is the most likely cause. Disabling them can quickly resolve the crash during shutdown.
Excel add-ins can sometimes conflict with the application's shutdown process, causing it to hang. Isolating and disabling the problematic add-in is the standard fix.
Open Microsoft Excel, click on 'File' in the top-left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, click on 'Add-ins' on the left sidebar.
At the bottom of the window, ensure the 'Manage' dropdown is set to 'COM Add-ins' and click the 'Go...' button.
Uncheck all the boxes in the list of available add-ins to disable them. Click 'OK', then restart Excel to see if it closes normally.
Run an Office Online Repair
If disabling add-ins doesn't work, repairing the Microsoft Office installation can fix corrupted application files causing the freeze.
Perform a Clean Boot or Test a New User Profile
If the issue returns after a repair, background software conflicts or a corrupted Windows user profile might be responsible.
Switch to WPS Office to Avoid Frustrating Crashes
If Microsoft Excel continues to freeze or crash and disrupts your workflow, consider switching to WPS Office. It provides a highly stable, lightweight, and completely free alternative for handling all your spreadsheet tasks without shutdown hangs.
- 1. Download and Install: Visit the WPS Office website and download the free installation package for your Windows PC.
- 2. Open WPS Spreadsheet: Launch the application and select 'Spreadsheet' from the main dashboard.
- 3. Load Your Excel Files: Drag and drop your existing .xlsx files directly into the workspace to continue working seamlessly.
Frequently Asked Questions
Why does Excel only crash when I try to close it?
This usually happens because Excel is trying to save preferences, clear temporary memory, or execute an active add-in script upon closing. If an add-in prevents the shutdown process from completing successfully, the application hangs.
Does reinstalling Microsoft Office fix the crashing issue?
Yes, reinstalling or running an Online Repair from the Control Panel replaces corrupted system files and registry keys that may be causing the application to freeze during exit.
What does opening Excel in Safe Mode do?
Starting Excel in Safe Mode bypasses all customized settings, templates, and COM add-ins. If Excel closes normally in Safe Mode, it confirms that a third-party add-in or custom setting is the root cause of the crash.
How do I know which add-in is causing Excel to freeze?
You can pinpoint the problematic add-in by disabling all of them first. If the crashing stops, re-enable them one by one, restarting Excel each time, until the crashing behavior returns. The last add-in enabled is the culprit.
