Excel Workbook Keeps Crashing? Fixes That Actually Help

Errors & fixes · Updated November 18, 2026

If an Excel workbook keeps crashing, first make a copy of the file, then open Excel in Safe Mode and test whether the problem is caused by an add-in or by the workbook itself. If the crash happens only with one file, use Excel’s Open and Repair option; if Excel crashes with many files, check add-ins, updates, and the Office installation.

Start with the safest checks

Before changing settings, preserve the current workbook. If it is stored on a network drive, removable drive, or cloud-synced folder, copy it to a local folder such as Documents and work on the copy. A connection interruption or a sync conflict can complicate troubleshooting, and saving repeatedly while a workbook is unstable can risk losing recent changes.

Then note what happens just before Excel closes: does it crash while opening the file, editing a particular sheet, refreshing data, printing, or saving? Also check whether other workbooks open normally. These details help distinguish a damaged file from an Excel-wide problem.

  • Restart Windows and open Excel again. This clears some temporary resource or background-process problems.
  • Try a blank workbook, then a different existing workbook. If those work but one file fails, focus on that workbook.
  • Make sure the computer has available disk space and close applications you do not need. Large workbooks and other running programs can compete for memory and system resources.
  • If Excel displays a recovery pane after restarting, save a recovered version under a new name before continuing.

A crash is different from a temporary calculation delay. If Excel says “Not Responding,” give it a little time, particularly after opening a large file or recalculating formulas. Forcing Excel to close immediately may discard unsaved work; if it remains unresponsive for a long time, close it through Task Manager only as a last resort.

Test Excel in Safe Mode

Safe Mode starts Excel without most add-ins and startup customizations. It is a useful diagnostic step, not a permanent repair. On Windows, press Windows key+R, type excel /safe, and press Enter. If Excel opens, try the problem workbook. If it works in Safe Mode but crashes in a normal session, an add-in or startup item is a likely cause.

To test add-ins in Microsoft 365 for Windows, open Excel normally and choose File > Options > Add-ins. At the bottom, select COM Add-ins in the Manage box and choose Go. Clear the check boxes to disable the listed add-ins, select OK, and restart Excel. If the crashes stop, enable add-ins one at a time, restarting and testing after each change, to identify the one associated with the problem. You can also check Excel Add-ins through the same Manage box.

Do not remove an add-in that your workplace requires without checking with your IT administrator. Some add-ins connect to databases, reporting systems, or other business software. On a Mac, Windows Safe Mode and the Windows COM Add-ins dialog do not apply; check Excel’s available add-in controls and test by disabling optional add-ins there. Menu names and available add-ins can differ by Excel version.

Check whether the workbook or Excel is at fault

If Excel crashes with just one workbook, the file may contain damaged content, a problematic connection, or a feature that triggers an error on your computer. Try opening a copy of the file on another trusted computer with a current Excel version. If it crashes there too, that points toward the workbook, although differences in add-ins, data access, or Excel versions can also matter. If several unrelated workbooks crash on the same computer, investigate Excel, add-ins, updates, or the computer environment instead.

When the file opens long enough to work, test a copy rather than the original. Try opening it with external links or data connections disconnected only if you understand the consequences: formulas may show old values, and refreshed data may not be available. A workbook that crashes during printing may involve a printer driver or page setup rather than damaged cell data. Test printing a different workbook and check whether changing the selected printer resolves the issue.

Workbooks downloaded from email or the web may also open in Protected View. Treat unexpected files cautiously; do not enable editing or content unless you trust the source. Protected View is a security feature, not proof that a file is damaged, and bypassing it is not a general crash fix.

Use Open and Repair for a damaged file

Excel for Microsoft 365 on Windows includes a repair option. In Excel, choose File > Open > Browse. Select the workbook in the file picker, click the arrow next to the Open button, and choose Open and Repair. Start with Repair. If Excel cannot repair the file, try Extract Data if that option is offered; it may recover values and formulas but will not necessarily preserve formatting, charts, or other workbook features.

Save any recovered content to a new file name and inspect it before replacing anything. Check important sheets, formulas, named ranges, charts, macros, and external data connections. Repair is an attempt to recover a workbook, not a guarantee that every part will be restored. Keep the original file untouched until you have checked the copy and confirmed that the information you need is present.

If the workbook is on OneDrive or SharePoint, check its version history before experimenting further. A previous version may be recoverable, depending on the location, account, and retention settings. Coordinate with colleagues before restoring a shared file, because the change could replace work added by someone else.

Reduce workbook features that strain Excel

Some workbooks become slow or unstable because they contain more calculation, formatting, or data than the computer can handle comfortably. Size alone does not prove a workbook is faulty: formulas, formatting, images, links, and add-ins all affect how it behaves. If a copy opens, make changes gradually and test after each one.

  • Check formulas and calculation: Large formula ranges and complex dependencies can make recalculation slow. Functions such as NOW, TODAY, RAND, OFFSET, and INDIRECT recalculate more often than many ordinary formulas. They are not inherently wrong, but a workbook with many such formulas may recalculate frequently.
  • Review formatting: Applying formatting to entire columns or rows, or accumulating excessive conditional-formatting rules, can add unnecessary work. Remove only formatting or rules you know are not needed, and keep a backup copy.
  • Inspect links and connections: Links to moved files, unavailable databases, or slow network locations can delay opening or refreshing. Review connections before removing them; deleting one can break a report that depends on it.
  • Consider workbook contents: Large images, embedded objects, pivot caches, and extensive data can increase file size or memory use. Remove or reorganize content only when you understand its purpose.

If calculations are the bottleneck, Excel for Windows offers calculation settings under Formulas > Calculation Options. Manual calculation can reduce repeated recalculation while you make changes, but formula results may then be out of date until you calculate again. Restore Automatic calculation when appropriate. This setting affects Excel’s calculation behavior, so tell anyone else using the workbook if you leave it changed.

Update or repair Microsoft 365

An outdated Excel build can contain bugs that have since been addressed, so install available updates before concluding that a workbook is irreparable. In Microsoft 365 for Windows, choose File > Account > Update Options > Update Now. Close other Office apps if prompted, then restart the computer and retest. Managed work computers may receive updates through an organization’s IT policies.

If Excel still crashes across multiple files, repair the Office installation. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, choose the three-dot menu, select Modify, and try Quick Repair first. If that does not help, Online Repair is a more thorough option and may take longer or require internet access. The exact labels can vary slightly by Windows build. Save your files and close Office apps before starting either repair.

On a Mac, install Office updates through Help > Check for Updates if Microsoft AutoUpdate is available; installations from the Mac App Store may use App Store updates instead. The Windows Settings repair options do not apply to macOS. If updating and disabling optional add-ins do not resolve repeated crashes, consult Microsoft support or the organization that manages the Mac before reinstalling Office.

Recover unsaved work and prevent repeat crashes

After an unexpected shutdown, reopen Excel and look for the Document Recovery pane. Open the most recent recovered version, compare it with the last saved file, and save the recovered work under a new name. If the pane is absent, Windows users can check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel had saved recoverable information; it may not include the latest edits.

AutoRecover and AutoSave are related but different. AutoRecover periodically stores recovery information according to settings under File > Options > Save in Excel for Windows. AutoSave is generally associated with files saved to OneDrive or SharePoint and can save changes as you work when available. Neither feature replaces a separate backup or guarantees recovery after every type of failure.

For prevention, keep Microsoft 365 updated, use a reliable storage location, and retain dated backup copies of important workbooks. For shared files, use the version history available in the storage service rather than keeping multiple people editing separate copies without a plan. If a workbook is business-critical, ask its owner or IT team to review data connections, macros, add-ins, and recovery procedures before making structural changes.

Frequently Asked Questions

Why does Excel crash when I open one specific file?
The workbook may be damaged, unusually resource-intensive, or dependent on a connection or feature that is failing. Work on a copy, test another workbook, and try File > Open > Browse > Open and Repair on Windows. If other files also crash, look beyond that one workbook.

Will Excel Safe Mode delete my files or settings?
No. Safe Mode is a diagnostic way to start Excel with add-ins and some customizations disabled. It does not repair or delete the workbook. Use it to compare behavior, then investigate add-ins if the crash happens only during a normal start.

Can I recover an Excel file after a crash?
Possibly. Reopen Excel and check the Document Recovery pane, or on Windows look under File > Info > Manage Workbook > Recover Unsaved Workbooks. Available recovery depends on AutoRecover settings and when Excel last saved recoverable data.

Why does Excel keep saying Not Responding?
Excel may be recalculating a large workbook, refreshing data, or waiting on a network resource. Give it time before closing it, and note which action causes the pause. If it repeatedly hangs, test a copy, check connections and add-ins, and consider whether the workbook’s formulas or contents are unusually demanding.

Should I reinstall Excel if it keeps crashing?
Not as the first step. Test Safe Mode, update Office, and use the available repair option for your operating system. If crashes continue across multiple workbooks after those checks, reinstalling or contacting Microsoft support may be reasonable; keep backups and confirm that you can sign back in before changing the installation.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.