sodcalculator

10 Tech How-To

Excel Keeps Crashing? 14 Fixes That Actually Work

Guide 10-45150 · Updated · Step by step

If Microsoft Excel keeps crashing on your computer, the cause is usually one of a few common issues: add-ins, corrupted files, outdated software, or hardware acceleration. Below are 14 fixes, ordered from the simplest to the most involved, that resolve the majority of crash reports.

Why Excel Crashes: The Usual Suspects

Excel is a complex application, and crashes can stem from many sources. Understanding the root cause helps you pick the right fix. The most frequent culprits are:

  • Problematic add-ins: Third-party add-ins (like data analysis tools or PDF converters) can conflict with Excel’s core code, especially after an update.
  • Corrupted workbooks: A single file with damaged formatting, formulas, or embedded objects can crash Excel every time you open it.
  • Outdated Office version: Microsoft regularly releases patches for known bugs. Running an old version leaves you vulnerable to crashes that are already fixed.
  • Hardware acceleration conflicts: Excel uses your GPU to render graphics. Outdated or incompatible display drivers can cause random crashes, especially with large charts or 3D models.
  • Insufficient memory or resources: Very large data sets (hundreds of thousands of rows) or too many open programs can exhaust your RAM, causing Excel to freeze and close.
  • Conflicting background processes: Other software, particularly antivirus or cloud sync tools, can interfere with Excel’s temporary files.

Fix 1: Restart Excel and Your Computer

It sounds trivial, but a fresh start clears temporary glitches. Close Excel completely, then restart your computer. This clears the memory and stops any background Excel processes that might be stuck. If Excel was in a “not responding” state, a restart is often the only way to regain control.

Fix 2: Disable Add-Ins

Add-ins are the number one cause of Excel crashes. To test if an add-in is the problem:

  1. Open Excel in Safe Mode: press Windows + R, type excel /safe, and press Enter. If Excel works fine in Safe Mode, an add-in is likely the culprit.
  2. Go to File > Options > Add-Ins.
  3. At the bottom, select COM Add-ins from the “Manage” dropdown and click Go.
  4. Uncheck all add-ins, then click OK. Restart Excel normally.
  5. If the crash stops, re-enable add-ins one by one to find the offender.

Fix 3: Repair the Office Installation

Corrupted program files can cause crashes. Windows has a built-in repair tool:

  1. Open Control Panel > Programs and Features.
  2. Select Microsoft Office (or Microsoft 365) and click Change.
  3. Choose Quick Repair first (takes about 5 minutes). If that doesn’t work, try Online Repair (takes longer but is more thorough).

Fix 4: Update Excel and Windows

Microsoft regularly releases updates that fix known crash bugs. To update Excel:

  1. In Excel, go to File > Account > Update Options > Update Now.
  2. Also check Windows Update in Settings > Update & Security and install any pending updates.

Fix 5: Turn Off Hardware Acceleration

If crashes happen when scrolling or using charts, the GPU rendering might be the issue. To disable it:

  1. Go to File > Options > Advanced.
  2. Scroll down to the Display section.
  3. Check the box for Disable hardware graphics acceleration.
  4. Restart Excel.

Fix 6: Update or Reinstall Display Drivers

Outdated graphics drivers are a common cause of Excel crashes. Visit your GPU manufacturer’s website (NVIDIA, AMD, Intel) to download the latest driver for your model. Alternatively, use Windows Device Manager to update the driver automatically. After updating, restart your computer.

Fix 7: Check for Corrupted Workbooks

If only one specific file crashes Excel, the file itself is likely damaged. Try these steps:

  • Open and Repair: In Excel, go to File > Open, select the file, click the arrow next to the Open button, and choose Open and Repair.
  • Open in a different program: Use Google Sheets or LibreOffice to open the file, then save it as a new .xlsx file. This can sometimes strip out the corruption.
  • Copy the data to a new workbook: Open the file in a viewer (like a web browser), copy the visible data, and paste it into a new Excel file. This loses formatting but often recovers the data.

Fix 8: Clear Excel’s AutoRecover and Temp Files

Corrupted temporary files can cause crashes. Close Excel, then delete the contents of the following folders (press Windows + R and paste each path):

  • %AppData%\Microsoft\Excel\ (delete everything inside, but note that this removes your custom settings)
  • %Temp% (delete everything you can; files in use will be skipped)

This is a bit aggressive, so only do it if other fixes fail.

Fix 9: Reduce Memory and Resource Usage

Large workbooks with complex formulas, volatile functions (like OFFSET, INDIRECT), or many conditional formatting rules can crash Excel. Try:

  • Convert formulas to values where possible (Copy > Paste Special > Values).
  • Remove unused cells and formatting by pressing Ctrl+End to find the last used cell, then delete all rows and columns beyond it.
  • Close other applications to free up RAM.

Fix 10: Run Excel in Compatibility Mode

If you’re using an older .xls file, Excel might crash. Save the file in the current .xlsx format via File > Save As. This resolves many issues related to legacy file formats.

Fix 11: Check Your Antivirus and Cloud Sync

Some antivirus programs scan Excel files in real-time, which can cause crashes. Temporarily disable your antivirus (or add Excel to the exclusion list) to test. Similarly, if you use OneDrive, Dropbox, or similar, pause syncing and see if the crashes stop. If they do, configure the sync tool to ignore Excel’s temp files.

Fix 12: Create a New User Profile

Your Windows user profile might be corrupted. Create a new user account in Windows and try opening Excel there. If it works, you’ll need to migrate your files and settings. This is a last-resort fix but is effective.

Fix 13: Use the Office Diagnostic Tool

Microsoft provides a diagnostic tool that can detect and fix certain issues. In Excel, go to File > Account > Support > Diagnostics (or search for “Diagnostics” in the search bar). Follow the on-screen instructions.

Fix 14: Reinstall Microsoft Office

If nothing else works, a full reinstall of Office is the most thorough fix. Uninstall Office via Control Panel > Programs and Features, restart your computer, then reinstall from your Microsoft account or installation media. This replaces all program files and resets all settings.

Frequently Asked Questions

Why does Excel crash when I open a specific file?

That file is likely corrupted. Use the “Open and Repair” feature (Fix 7) or open it in a different program like Google Sheets and save it as a new .xlsx file. If the crash persists, the file may contain a malicious macro or an object that Excel can’t handle.

Can an Excel add-in really cause crashes?

Yes, absolutely. Third-party add-ins are the most common cause of Excel crashes after updates. They run code that can conflict with Excel’s internal functions. Always test in Safe Mode (Fix 2) to isolate the issue.

What does “Excel is not responding” mean?

It means Excel is stuck in a loop, often due to a heavy calculation or a bug. Wait a few seconds; if it doesn’t recover, you’ll need to force-close it. Then apply the fixes above, particularly disabling add-ins and hardware acceleration.

Will I lose my data if Excel crashes?

Not necessarily. Excel has AutoRecover, which saves versions of your work every few minutes. After a crash, reopen Excel and you’ll see a “Document Recovery” pane on the left. Save the recovered version immediately. To be safe, enable AutoSave (if using OneDrive) and set AutoRecover to save every 1 minute.

Should I use the 64-bit or 32-bit version of Excel?

If you have large data sets (over 2 GB), the 64-bit version is better because it can use more RAM. The 32-bit version is limited to 2 GB and crashes more often with big files. To check which you have, go to File > Account > About Excel. You can reinstall Office with the 64-bit version if needed.

Is there a way to prevent Excel crashes in the future?

Yes. Keep Excel and Windows updated, avoid installing too many add-ins, regularly save your work with AutoSave, and try to keep your workbooks under 100 MB. Also, periodically clear the temp files and avoid using volatile functions excessively.

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

The whole Tech How-To bed →