How to Fix Excel That Keeps Crashing or Not Responding
Published 2026-10-16 · Marion Remote Fix
Excel displays "Not Responding" in the title bar, freezes when you open a specific file, crashes to desktop without warning, or hangs during calculations. These problems are usually caused by a conflicting add-in, a corrupted workbook, insufficient resources for a large spreadsheet, or a damaged Office installation. Here is how to fix each one.
Start Excel in Safe Mode
Excel Safe Mode disables all add-ins, custom toolbars, and startup files. If Excel works fine in Safe Mode, an add-in or customization is causing the crash:
- Close Excel completely
- Press Win+R, type
excel /safe, press Enter - Excel opens with "(Safe Mode)" in the title bar. Try opening the file that was causing problems
- If it works in Safe Mode, the cause is an add-in — see the next section
- If it still crashes in Safe Mode, the issue is the file itself or the Office installation
Disable add-ins
Add-ins are the most common cause of Excel crashes. Third-party add-ins (PDF converters, data connectors, accounting tools, CRM integrations) and even some Microsoft add-ins can conflict with each other or with Excel updates:
- Open Excel in Safe Mode (Win+R →
excel /safe) - Click File → Options → Add-ins
- At the bottom, next to Manage, select COM Add-ins → click Go
- Uncheck ALL add-ins → OK
- Close Excel and reopen it normally (not Safe Mode)
- If the crashing stops, re-enable add-ins one at a time to identify which one causes the problem. Re-enable one, test, then enable the next. The one that causes a crash is the culprit
Also check for Excel Add-ins (different from COM Add-ins): File → Options → Add-ins → Manage → Excel Add-ins → Go. Disable any that you do not actively use.
Repair the workbook
If Excel crashes only when opening a specific file, that file may be corrupted:
Use Excel's built-in repair
- Open Excel (do not open the file directly)
- Click File → Open → Browse → navigate to the file
- Instead of clicking Open, click the small dropdown arrow next to the Open button → select Open and Repair
- Try Repair first. If that does not work, try Extract Data (this recovers values and formulas but loses formatting)
Recover data from a corrupted file
- Try opening the file in Google Sheets (upload to Google Drive → Open with Google Sheets). Google Sheets has different parsing logic and can sometimes read files that Excel cannot
- Try opening the file in LibreOffice Calc (free download). It may recover data that Excel's repair tool cannot
- If the file has macros (VBA code) that may be corrupted, try opening it with macros disabled: File → Options → Trust Center → Trust Center Settings → Macro Settings → Disable all macros without notification. Reopen the file
Recover unsaved work
If Excel crashed and you lost unsaved changes:
- Reopen Excel. It should show a Document Recovery pane on the left with auto-recovered versions of your files. Click the most recent version to recover it
- If the recovery pane does not appear: File → Info → Manage Workbook → Recover Unsaved Workbooks. This opens the folder where Excel stores auto-recovery files
- Auto-recovery files are stored at
C:\Users\YourName\AppData\Roaming\Microsoft\Excel\— check this folder for .xlsb or .xar files with recent modification dates - To prevent future data loss, enable AutoSave: File → Options → Save → set "Save AutoRecover information every" to 5 minutes or less. For Microsoft 365 users, enable AutoSave to OneDrive (toggle at the top-left of the Excel window) for real-time saving
Fix Excel freezing on large files
Excel can freeze when working with large spreadsheets (100,000+ rows, heavy formulas, multiple pivot tables). This is a resource issue, not a bug:
- Turn off automatic calculation: Formulas tab → Calculation Options → Manual. This stops Excel from recalculating every formula every time you change a cell. Press Ctrl+Shift+F9 to recalculate manually when needed
- Reduce volatile functions: functions like INDIRECT, OFFSET, TODAY, NOW, and RAND recalculate every time anything changes. Replace them with non-volatile alternatives where possible (INDEX/MATCH instead of INDIRECT, static dates instead of TODAY)
- Close unnecessary workbooks: every open workbook consumes memory. Close files you are not actively editing
- Simplify conditional formatting: complex conditional formatting rules applied to entire columns (like A:A instead of A1:A10000) force Excel to evaluate millions of cells. Limit the range of conditional formatting rules to actual data ranges
- Check array formulas: large array formulas (especially CSE formulas in older Excel) or XLOOKUP/FILTER across huge ranges can consume significant memory. Consider using Power Query or pivot tables for large dataset analysis instead of cell formulas
Update Office
Microsoft releases monthly patches that fix Excel crashes and compatibility issues:
- Open Excel → File → Account → Update Options → Update Now
- If updates are managed by your organization, you may need to contact IT
- If the crashes started after a recent update, you can roll back: File → Account → Update Options → View Update History to see the latest update, then uninstall it from Settings → Apps → Microsoft Office → Modify
Repair the Office installation
If Excel crashes regardless of which file you open and Safe Mode did not help, the Office installation may be corrupted:
- Open Settings → Apps → Installed apps → find Microsoft Office or Microsoft 365 → click the three dots → Modify
- Try Quick Repair first (takes a few minutes, does not require internet)
- If Quick Repair does not fix it, try Online Repair (downloads and reinstalls Office components — requires internet and takes longer but is more thorough)
Check for conflicting software
- Antivirus: some antivirus programs scan every file Excel opens, which can cause freezing or crashes. Add your Excel data folders to the antivirus exclusion list
- PDF printers: virtual PDF printers (CutePDF, PDF24, Bullzip) can conflict with Excel's print engine. Try removing them temporarily to test
- Outdated .NET Framework: some Excel features depend on .NET Framework. Run Windows Update to get the latest .NET version
Remote Excel troubleshooting
If Excel keeps crashing or freezing after trying the steps above, Marion Remote Fix can diagnose the issue remotely — disabling conflicting add-ins, repairing corrupted workbooks, optimizing large spreadsheets, and repairing the Office installation through a secure remote session.