If Excel keeps crashing, the fix usually starts with disabling add-ins and repairing the Office installation, which resolves a large share of crashes. Below are the most effective troubleshooting steps, from quick checks to deeper repairs, along with causes and prevention tips.
Why Does Excel Crash?
Excel crashes can stem from many sources, but the most common are problematic add-ins, corrupted files, outdated Office versions, and conflicts with other software. Add-ins, especially third-party ones, load with Excel and can cause instability. Corrupted workbooks or a damaged Office installation also trigger frequent crashes. Less common but possible causes include hardware acceleration issues, printer drivers, and conflicts with antivirus or other background programs.
Quick Checks Before You Troubleshoot
Before diving into deeper fixes, try these quick steps—they often resolve the issue immediately:
- Restart Excel and your computer. A simple restart clears temporary glitches.
- Update Windows and Office. Go to File > Account > Update Options > Update Now in Excel to install the latest patches.
- Open Excel in Safe Mode. Press Win + R, type
excel /safe, and press Enter. If Excel works fine in Safe Mode, an add-in or customization is likely the culprit. - Check if the problem is with a specific file. Try opening other workbooks. If only one file crashes, the file itself may be corrupted.
Disable Problematic Add-Ins
Add-ins are a leading cause of Excel crashes. To disable them:
- Go to File > Options > Add-Ins.
- At the bottom, next to Manage, select COM Add-ins and click Go.
- Uncheck all add-ins and click OK.
- Restart Excel. If the crash stops, re-enable add-ins one by one to identify the culprit.
Common problematic add-ins include older versions of Acrobat, third-party data tools, and some antivirus integrations. If you find a specific add-in causes crashes, check for an update or contact the vendor.
Repair Your Office Installation
If disabling add-ins doesn’t help, the Office installation itself may be damaged. Use the built-in repair tool:
- Open Control Panel > Programs > Programs and Features.
- Find Microsoft 365 or Office in the list, select it, and click Change.
- Choose Quick Repair first. If that doesn’t work, try Online Repair (requires internet and may take longer).
This process replaces corrupted Office files without affecting your data. It’s a standard fix that resolves many persistent crashes.
Handle Corrupted Workbooks
If only a specific workbook crashes, it may be corrupted. Try these recovery steps:
- Open and Repair: In Excel, go to File > Open, select the file, click the arrow next to Open, and choose Open and Repair.
- Recover unsaved workbooks: Go to File > Info > Manage Workbook > Recover Unsaved Workbooks to find recent auto-saved versions.
- Copy data to a new workbook: If the file is severely damaged, try copying the data to a new workbook manually, or use the Move or Copy feature to move sheets.
To prevent future corruption, enable AutoSave (if using OneDrive) and set frequent AutoRecover intervals (File > Options &em>Save).
Adjust Excel Options to Improve Stability
Some Excel features can cause crashes on certain hardware. Try these tweaks:
- Disable hardware graphics acceleration: Go to File > Options > Advanced, scroll to Display, and check Disable hardware graphics acceleration.
- Disable the “Ignore other applications that use Dynamic Data Exchange (DDE)” (in Advanced > General) if you see the “Excel is waiting for another application” error.
- Clear the AutoRecover file location: In Options > Save, change the AutoRecover file location to a local folder (not a network drive) and clear old files.
These options are safe to toggle and can be reverted if they don’t help.
When All Else Fails: Reinstall or Use Alternatives
If none of the above works, a full uninstall and reinstall of Office may be necessary. Use the Microsoft Support and Recovery Assistant tool to fully remove Office, then reinstall from your Microsoft account. Before doing this, back up your Excel files and note your product key (if applicable).
If you need to get work done immediately, consider using Excel Online (free with a Microsoft account) or Google Sheets as a temporary alternative. These web-based tools can open and edit most Excel files without the same crash issues.
Frequently Asked Questions
Why does Excel crash when I open a specific file?
That file is likely corrupted. Try the Open and Repair feature, or copy the data to a new workbook. If the file is stored on a network drive, move it locally first.
How do I recover an unsaved Excel file after a crash?
Open Excel and go to File > Info &em> Manage Workbook > Recover Unsaved Workbooks. If you have AutoRecover enabled, you may also find files in the AutoRecover file location (usually %AppData%\Microsoft\Excel\).
Can add-ins really cause Excel to crash?
Yes, especially third-party add-ins that are outdated or incompatible with your Excel version. Disable them to test, and re-enable one by one to find the culprit.
Does Excel crash more on Mac or Windows?
Crash rates vary by version and hardware, but the troubleshooting steps are similar on both platforms. On Mac, check for updates and try resetting Excel’s preferences if issues persist.
Should I disable hardware acceleration to fix crashes?
It’s worth trying if you experience graphical glitches or crashes during scrolling or zooming. This option is in File > Options > Advanced > Display.
Will reinstalling Office delete my files?
No, uninstalling Office does not delete your Excel files, but it’s always wise to back them up. You’ll need to sign in again and may need to re-enter your product key.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Change Google Text-to-Speech Voice on Android
- How to Adjust Volume Levels on a Windows PC
- Reset Chrome Sync to Fix Problems
- Fix Mouse Not Working in Windows 11
- Fix Windows Defender Failed to Initialize Error
- Windows 11 KB5083769 Boot Loop: Fix Steps