'%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)
Fix Excel Error That Prevents the Application from Working
Question details
The user needs to troubleshoot a critical message stating Excel has encountered an error and must be closed, which prevents the application from launching or working properly.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening or working within the Microsoft Excel application.
- Observed behavior
- Microsoft Excel displays an error message stating that it has encountered an error and must close, forcing the application to terminate.
Ensure you have saved any open documents in other Office applications, as updating or repairing Microsoft Excel may require you to close all Office programs or restart your computer.
Update Excel and Disable Conflicting Add-ins in Safe Mode
Outdated software or incompatible third-party add-ins are common causes for Excel crashing. Running the application in Safe Mode helps isolate and resolve the conflict.
Safe Mode starts Excel with a minimal set of features, temporarily bypassing add-ins and custom settings. If Excel opens without errors in this mode, an add-in is likely causing the crash.
Open Excel normally (if possible), navigate to 'File' > 'Account' > 'Update Options', and click 'Update Now'. Allow the updates to install.
Hold down the 'Ctrl' key on your keyboard while clicking the Excel shortcut to launch it. Confirm that you want to start the application in Safe Mode.
If Excel opens successfully in Safe Mode, go to 'File' > 'Options' > 'Add-ins'. Select 'COM Add-ins' from the Manage drop-down and click 'Go'. Uncheck all add-ins to disable them, then restart Excel normally to see if the issue is resolved.
Run a Quick Repair for Microsoft Office
If Excel still fails to work or refuses to open in Safe Mode, repairing the Office installation can fix corrupted application files automatically.
Completely Reinstall Microsoft Office
As a last resort, reinstalling Office will replace all core software files if the Quick Repair fails to resolve the fatal error.
Try WPS Office for a Stable and Free Spreadsheet Experience
If Microsoft Excel continues to crash or requires lengthy troubleshooting, WPS Office provides a lightweight, reliable, and completely free alternative. It features a familiar interface, highly stable performance, and seamless migration for all your spreadsheet tasks.
- 1. Download and Install: Download WPS Office for free from the official website and run the quick installation.
- 2. Open WPS Spreadsheets: Launch the application and select 'Spreadsheets' from the main dashboard.
- 3. Load Your Excel File: Click 'Open' and select your existing .xlsx or .xls files to continue working immediately without data loss or crashes.
Frequently Asked Questions
Why does Excel keep saying it has encountered an error and needs to close?
This fatal error is typically caused by outdated Microsoft Office software, conflicting third-party COM add-ins, corrupted Windows system files, or conflicts triggered by a recent Windows OS update.
Will I lose my saved spreadsheets if I run Quick Repair on Microsoft Office?
No, running a Quick Repair only scans and replaces corrupted application files and settings. Your saved Excel workbooks, personal data, and documents will remain fully intact.
What should I do if Safe Mode doesn't fix the Excel error?
If Excel still crashes while operating in Safe Mode, the issue is likely unrelated to add-ins. You should proceed with running a Quick Repair from the Windows Control Panel, or consider uninstalling and reinstalling Microsoft Office.
How do I know exactly which add-in is causing Excel to crash?
While in Safe Mode, disable all of your add-ins, then enable them one by one. Restart Excel normally after enabling each individual add-in. The add-in that causes the application to trigger the error again is the one responsible.
