Excel Keeps Crashing on Windows? Fixes That Work

If Excel keeps crashing on Windows, the cause is usually a faulty add-in, a corrupted file, or a problem with the Office installation itself—and most of the time you can fix it in under 15 minutes without reinstalling. This guide walks you through the most effective troubleshooting steps, from safe mode and add-in management to repairing Office and dealing with problematic files. You’ll also learn what to do when Excel crashes on open, during saving, or when you’re working with large workbooks.

Why Excel Crashes on Windows

Excel crashes for many reasons, but they tend to fall into a few common categories. Understanding the root cause helps you pick the right fix instead of trying random solutions.

• Add-ins and COM add-ins – Third-party tools (like data analysis packs, PDF converters, or ERP connectors) can conflict with Excel’s code, especially after a Windows or Office update.
• Corrupted workbooks – A single file with broken formatting, invalid references, or leftover macros can crash Excel every time you open it, while other files work fine.
• Faulty Office installation – Missing updates, damaged installation files, or conflicts with other software can make Excel unstable across all files.
• Hardware acceleration or graphics drivers – Excel uses your GPU for rendering; outdated or buggy drivers can cause crashes, especially when scrolling or zooming.
• Memory or resource exhaustion – Very large datasets, many open workbooks, or insufficient RAM can make Excel run out of memory and close unexpectedly.
• Antivirus or security software – Some security tools interfere with Excel’s file access or macro execution, triggering crashes.

First Steps: Run Excel in Safe Mode

Safe Mode starts Excel without add-ins, custom toolbars, or the Alternate Startup folder. It’s the fastest way to tell if an add-in or customization is the culprit.

1. Press Windows + R, type excel /safe, and press Enter. (Note the space before the slash.)
2. If Excel opens fine in Safe Mode, the problem is likely an add-in or a setting. Go to File > Options > Add-ins.
3. At the bottom, next to “Manage,” select COM Add-ins and click Go.
4. Uncheck all add-ins, click OK, and restart Excel normally. If it works, re-enable add-ins one by one to find the offender.
5. If you still crash, repeat with “Excel Add-ins” and “Disabled Items” to check those as well.

If Safe Mode also crashes, the issue is more fundamental—move on to repairing Office.

Repair Your Office Installation

When Excel crashes even in Safe Mode, the installation itself may be damaged. Windows includes a built-in repair tool that often fixes this without a full reinstall.

1. Open Settings > Apps > Installed apps (or Apps & features on older Windows).
2. Find Microsoft 365 or Microsoft Office in the list, click the three-dot menu, and choose Modify (or Change).
3. Select Quick Repair first—it’s faster and doesn’t require internet. If that doesn’t help, choose Online Repair for a deeper fix.
4. Follow the prompts and restart your PC when done.

Online Repair can take 30 minutes or more, but it replaces all Office files and often resolves persistent crashes. After the repair, test Excel with a blank workbook before opening your usual files.

Deal With Problematic Workbooks

If Excel only crashes when you open certain files, the issue is likely the file itself. Here’s how to work around it:

• Open and repair – In Excel, go to File > Open > Browse, select the file, click the arrow next to Open, and choose Open and Repair. This attempts to recover the file.
• Open in a different app – Google Sheets or LibreOffice Calc can often open a corrupted file. Save it as a new .xlsx, then reopen in Excel.
• Copy the data to a new workbook – If you can open the file at all, copy the used range and paste it into a fresh workbook (use Paste Special > Values to strip formatting if needed).
• Check external links – Workbooks that reference other files (e.g., ='[Budget.xlsx]Sheet1'!A1) can crash if the source file is missing or locked. Break links via Data > Edit Links.
• Disable hardware acceleration – Go to File > Options > Advanced, scroll to Display, and check Disable hardware graphics acceleration. This helps with rendering-related crashes.

Update Windows, Office, and Drivers

Outdated software is a common cause of crashes, especially after a major Windows update. Keeping everything current prevents many issues.

1. Run Windows Update – Go to Settings > Windows Update and install all pending updates, including optional ones.
2. Update Office – In Excel, go to File > Account > Update Options > Update Now.
3. Update your graphics driver – Visit your GPU manufacturer’s website (NVIDIA, AMD, Intel) or use Windows Device Manager to check for updates. Outdated drivers are a known cause of Excel crashes when scrolling or zooming.
4. If you recently installed a Windows update and crashes started, try Uninstall updates from Windows Update settings to see if that resolves it.

Check for Memory and Performance Issues

Excel is a 64-bit application on modern Windows, but it still has limits. If you work with massive datasets, you may hit memory ceilings.

• Close other programs – Browsers with many tabs, video editors, or virtual machines consume RAM. Free up memory before opening heavy workbooks.
• Reduce workbook size – Remove unused formatting (select all cells, then Clear > Clear Formats only if you don’t need them), delete unused defined names, and convert formulas to values where possible.
• Split large workbooks – If you have a file with hundreds of thousands of rows, consider using Power Query or a database instead of Excel.
• Check for infinite loops – A volatile function like NOW() or OFFSET() used excessively can slow Excel to a crawl and make it appear frozen. Replace with static values when possible.
• Run a memory test – If crashes are random and happen in other apps too, your RAM may be faulty. Use Windows Memory Diagnostic (search “Windows Memory Diagnostic” in Start).

When All Else Fails: Reset Excel Settings

If nothing above works, you can reset Excel to its default state. This clears custom settings, toolbars, and the registry keys that control Excel’s behavior.

1. Close all Office apps.
2. Press Windows + R, type regedit, and press Enter to open the Registry Editor.
3. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel (the “16.0” folder is for Office 2016, 2019, and Microsoft 365; older versions use 15.0 for 2013).
4. Right-click the Excel key and choose Export to back it up, then delete the key.
5. Restart Excel. It will recreate default settings.

If you’re not comfortable editing the registry, you can also try File > Options > Trust Center > Trust Center Settings and disable all “Protected View” options temporarily to see if that helps (re-enable them afterward for security).

Frequently Asked Questions

Why does Excel keep crashing when I open a specific file?
That file is likely corrupted or contains an element (like a broken macro or external link) that Excel can’t handle. Use Open and Repair, open it in Google Sheets to convert it, or copy the data to a new workbook.

Does Excel crash more often with 32-bit or 64-bit?
64-bit Excel can handle much larger workbooks and more memory, so it’s generally more stable for big data. If you have 32-bit Office, upgrade to 64-bit if your system supports it, but note that some old add-ins only work with 32-bit.

Can antivirus software cause Excel to crash?
Yes. Some security tools scan every file Excel opens, which can interfere with file locking or macro execution. Try temporarily disabling your antivirus (if safe) to test, or add Excel and your workbook folders to the exclusion list.

How do I recover unsaved work after a crash?
Open Excel, go to File > Info > Manage Workbook, and click Recover Unsaved Workbooks. Excel also shows a Document Recovery pane on restart. Enable AutoSave and set AutoRecover to every 5 minutes in File > Options > Save to minimize loss.

Is there a way to prevent Excel from crashing with large data?
Use Excel’s Data Model (Power Pivot) for millions of rows, avoid volatile functions, and keep formatting clean. Also ensure you have enough RAM and close other apps. If you still crash, consider a 64-bit version of Office.

What should I do if Excel crashes during startup every time?
Try starting in Safe Mode (excel /safe). If that works, disable add-ins. If not, run Quick Repair from Settings. If that fails, do an Online Repair or reset Excel’s registry key as described above.

Related

• Secure a Linux VPS with Two-Factor Authentication
• One VPN Subscription on Multiple Devices: How It Works
• Spotify Canvas Not Working on Android & iPhone: Fixes