Excel Keeps Crashing or Freezing — How to Fix It

If Microsoft Excel keeps freezing, crashing, or showing “Not Responding” in the title bar, there are a handful of well-known causes — and most of them have a straightforward fix. This guide works through the most effective solutions in order, starting with the quickest to try.

Step 1: Open Excel in Safe Mode

Safe Mode starts Excel with all add-ins and customisations disabled. It’s the fastest way to find out whether the crash is caused by Excel itself or by something running alongside it.

How to do it

1. Close Excel completely.
2. Hold down the Ctrl key and double-click the Excel icon (or click a file).
3. A dialogue will ask if you want to start in Safe Mode — click Yes.

If Excel runs normally in Safe Mode, the problem is with an add-in or a startup file, not Excel itself. If it still crashes in Safe Mode, the issue is more likely file corruption, an Office installation problem, or a system-level issue.

Step 2: Disable Add-ins One at a Time

Add-ins are small programmes that plug into Excel. They include things like analysis toolpacks, PDF exporters, and third-party tools. A faulty add-in is one of the most common causes of Excel crashing — especially after an Office update, which can cause older add-ins to break.

How to disable add-ins

1. Go to File > Options > Add-ins.
2. At the bottom of the screen, make sure the dropdown says COM Add-ins and click Go.
3. Uncheck all add-ins and click OK.
4. Restart Excel normally (not in Safe Mode) and test whether the problem has gone.
5. If it’s stable, re-enable the add-ins one at a time, restarting Excel each time, until the crash comes back. The last one you enabled is the problem.

Repeat the process for Excel Add-ins in the same dropdown if COM Add-ins didn’t help.

Step 3: Repair Your Office Installation

If Safe Mode and disabling add-ins don’t help, the Office installation itself may be damaged. Microsoft includes a built-in repair tool that can fix this without uninstalling Office.

How to run a Quick Repair

1. Close all Office applications.
2. Open Control Panel > Programs > Programs and Features.
3. Find Microsoft 365 (or Microsoft Office) in the list, right-click it, and select Change.
4. Select Quick Repair and follow the prompts.

Quick Repair takes a few minutes and doesn’t need an internet connection. If it doesn’t resolve the issue, go back and run Online Repair — this is more thorough but takes longer and requires an internet connection.

Step 4: Check Whether a Specific File Is Causing the Crash

Sometimes Excel itself is fine, but one particular workbook is corrupt. The easiest way to test this is to open a blank workbook — if Excel is stable with a blank file, the problem is almost certainly with the file you were working in.

How to recover data from a corrupt file

1. Open Excel and go to File > Open.
2. Browse to the file, but don’t double-click it.
3. Click the dropdown arrow next to the Open button and select Open and Repair.
4. Choose Repair first. If that doesn’t work, try Extract Data to salvage at least the values.

It’s also worth checking your AutoRecover folder. Go to File > Options > Save and look at the AutoRecover file location. Browse to that folder in File Explorer — you may find a recent auto-saved version of the file that isn’t corrupt.

Step 5: Fix Excessive Conditional Formatting

Conditional formatting rules can multiply quietly over time, especially in files that have been copied, pasted into, and edited repeatedly. A workbook with thousands of redundant formatting rules can slow Excel to a crawl or cause it to freeze when scrolling or editing.

How to clean it up

1. Select all cells (Ctrl+A).
2. Go to Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet.
3. If you need to keep some rules, go to Manage Rules and delete duplicates or rules that cover large ranges unnecessarily.

What to Do When Excel Crashes on Large Files

Large workbooks — especially those with hundreds of thousands of rows, many sheets, or complex formulas — put heavy demands on Excel. If crashes only happen with big files, try these approaches:

Split the data across multiple workbooks

If one file contains several years of data, split it by year. Link summary sheets to the individual files if you need a consolidated view.

Avoid volatile functions in large workbooks

Functions like NOW(), TODAY(), OFFSET(), INDIRECT(), and RAND() recalculate every time anything in the workbook changes. In a large file, this can cause noticeable lag or freezing. Replace them with non-volatile alternatives where possible — for example, use a fixed date value instead of TODAY() if the date doesn’t need to update automatically.

Remove excessive formatting

Formatting entire columns or rows (rather than just the cells with data) bloats the file size. Select only the cells that actually contain data and apply formatting there. Use File > Info > Check for Issues > Inspect Document to find hidden data and redundant styles.

Switch to Manual calculation mode temporarily

If you need to work with a large file without constant recalculation slowing you down, go to Formulas > Calculation Options > Manual. Press F9 to recalculate when you need to. Remember to switch back to Automatic when you’re done.

Other Things Worth Checking

Graphics driver issues

Excel uses hardware acceleration for rendering. If your graphics driver is outdated or buggy, it can cause Excel to freeze or display corrupted graphics. Try disabling hardware acceleration: go to File > Options > Advanced, scroll to the Display section, and tick Disable hardware graphics acceleration.

Windows and Office updates

Make sure Windows is fully up to date (Settings > Windows Update) and that Office has the latest updates installed (File > Account > Update Options > Update Now). Many stability issues are fixed in patches.

Antivirus interference

Some antivirus programmes scan Office files in real time, which can slow Excel significantly or cause it to hang when saving. Try temporarily disabling real-time protection to see if it makes a difference — if it does, add Excel and your documents folder to the antivirus exclusions list.

Summary: In What Order to Try These Fixes

1. Open in Safe Mode to isolate the cause.
2. Disable COM Add-ins and test each one.
3. Run Quick Repair on Office.
4. Try opening a blank workbook — if that’s fine, use Open and Repair on the problem file.
5. Clear excessive conditional formatting.
6. For large files: split data, remove volatile functions, reduce formatting.
7. Disable hardware acceleration if you see display issues.
8. Check for Windows and Office updates.

In most cases, the problem is either a rogue add-in or a corrupt file. Safe Mode will tell you which within a couple of minutes, and from there the fix is usually straightforward.