'%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 When Opening Files With an Error Message
Question details
The user experiences Microsoft Excel crashing immediately after opening files, accompanied by an error message stating it has encountered an error.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening existing workbooks in Microsoft Excel
- Observed behavior
- Excel displays 'We are sorry, but Excel has encountered an error that is preventing it from working correctly' and closes. The built-in 'Repair Now' option does not resolve the issue.
Ensure all Microsoft Office applications are completely closed and save any unsaved work in other running programs, as the repair process will require a system restart.
Perform a Full Online Repair via Windows Settings
Use the comprehensive Online Repair tool to download and replace corrupted Microsoft Office installation files that the quick 'Repair Now' button fails to fix.
Because this error can affect the entire Office suite, running an Online Repair is the most effective solution. It takes approximately 15–30 minutes and requires an active internet connection.
Click the Start menu and select the gear icon to open Windows Settings, then navigate to 'Apps' and select 'Installed apps' (or 'Apps & features').
Scroll down or search to find 'Microsoft 365' or 'Microsoft Office'. Click the three-dot menu icon next to it and select 'Modify'.
In the pop-up dialog, select 'Online Repair' (rather than Quick Repair) and click the 'Repair' button. Allow the process to finish without canceling it.
Once the repair is completely finished, restart your PC and try opening your Excel file again.
Test Excel in Safe Mode and Disable Add-ins
Launch Excel without loading any third-party add-ins to determine if a malfunctioning plugin is responsible for the crash.
Try WPS Office When Excel Keeps Crashing
If Microsoft Excel continues to crash or requires time-consuming troubleshooting, consider switching to WPS Office. It is a highly stable, lightweight alternative that opens your existing spreadsheets seamlessly.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for Windows.
- 2. Install WPS Office: Run the installer. The lightweight package installs in just a few minutes.
- 3. Open Your Workbooks: Right-click your crashing .xlsx file, choose 'Open with', and select WPS Spreadsheets to view and edit your data safely.
Frequently Asked Questions
What does the 'Excel has encountered an error' message mean?
This generic error indicates that Excel's core application files are corrupted, a background process is interfering with the software, or an incompatible third-party add-in is forcing the application to shut down.
Why didn't the 'Repair Now' button work?
The built-in 'Repair Now' prompt typically attempts a very superficial quick fix. A full Online Repair via Windows Settings is usually required because it actually downloads and replaces the damaged installation files from Microsoft's servers.
How do I find out which add-in is causing Excel to crash?
Boot Excel in Safe Mode by typing 'excel /safe' in the Windows Run dialog. If it opens successfully without crashing, go to File > Options > Add-ins, disable all COM Add-ins, and then re-enable them one by one. Restart Excel each time to isolate the specific plugin causing the issue.
