'%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 Closes Unexpectedly with Error Message
Question details
The user experiences sudden crashes in Microsoft Excel, accompanied by an error message stating the program has encountered an error.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Working on or opening an Excel workbook when the application suddenly crashes.
- Observed behavior
- Excel closes unexpectedly without warning, displays a generic error message, and the built-in repair prompt may fail to resolve the issue.
Before troubleshooting, ensure you have saved any open files in other Office applications and check if your Windows operating system has any pending updates.
Start Excel in Safe Mode and Disable Add-ins
Running Excel in Safe Mode helps identify if a third-party add-in is causing the application to crash unexpectedly.
Add-ins can sometimes conflict with Excel's core operations, leading to sudden closures. Safe Mode bypasses these add-ins, allowing you to isolate the problematic extension.
Press the Windows key + R simultaneously on your keyboard to open the Run window.
Type 'excel /safe' in the box and press Enter. If Excel opens successfully without crashing, an add-in is likely the culprit.
Go to File in the top-left corner, click Options, and select Add-ins from the left sidebar.
At the bottom of the window, change the Manage dropdown to 'COM Add-ins' and click Go. Uncheck all add-ins and click OK, then restart Excel normally to see if the issue is resolved.
Repair Microsoft Office from Windows Settings
If installation files are corrupted, using the built-in Windows repair tool for Microsoft 365 can fix the crashing issue.
Update or Reinstall Microsoft Office
Outdated software can cause unexpected errors. Updating or reinstalling Office ensures you have the latest bug fixes.
Try WPS Office When Excel Keeps Crashing
If Microsoft Excel continues to close unexpectedly and standard repair tools fail, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative that opens your existing spreadsheets without the frustration of constant crashing.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for Windows.
- 2. Install the software: Run the installer and follow the on-screen instructions to complete the setup in minutes.
- 3. Open your Excel files: Launch WPS Spreadsheet and open your existing .xlsx files seamlessly to resume your work without data loss.
Frequently Asked Questions
Why does Excel say it has encountered an error and needs to close?
This error is typically caused by conflicting third-party add-ins, corrupted Office installation files, outdated software, or interference from background antivirus programs.
Will I lose my data if Excel closes unexpectedly?
If AutoRecover is enabled in your settings, Excel will attempt to save a backup of your work. You can usually recover it by reopening Excel and checking the Document Recovery pane that appears on the left side.
How do I open a corrupted workbook that is causing Excel to crash?
Open Excel first without opening the file. Go to File > Open, select your corrupted file, click the small arrow next to the Open button at the bottom, and choose 'Open and Repair' to attempt data recovery.
What should I do if the Microsoft Office repair tool also fails?
If the repair tool fails, it indicates severe corruption in the installation files. You will need to completely uninstall Microsoft Office, ideally using the Microsoft Support and Recovery Assistant tool, and then reinstall a fresh copy from your Microsoft account.
