Excel Worksheet Keeps Crashing? Causes, Checks and Fixes

Errors & fixes · Updated November 18, 2026

If an Excel worksheet keeps crashing, first find out whether Excel fails with every workbook or only one, then open Excel in Safe Mode and disable add-ins to check for a conflict. Save a copy of the affected file before troubleshooting; if the problem follows that file, use Excel’s Open and Repair command and check its formulas, links, and size.

Why Excel crashes—and why the distinction matters

Excel can close unexpectedly, freeze and stop responding, or show an error when opening a particular workbook. These symptoms can have different causes. A problem across several files may point to an Excel add-in, damaged Office installation, outdated software, or limited system resources. A problem isolated to one file is more likely to involve that workbook’s contents, structure, or storage location.

“Worksheet” is often used to mean the whole Excel file, but a worksheet is one tab inside a workbook. A crash can happen while opening a workbook, recalculating formulas, refreshing data, editing a sheet, or saving. Notice when it occurs: for example, does Excel fail immediately on opening, only after clicking Enable Content, or when a large formula recalculates? That detail helps narrow the investigation.

A freeze is not always a crash. A large calculation or data refresh can make Excel appear unresponsive while it is still working. If the status bar shows activity, or the workbook is especially large, allow time for the operation to finish before force-quitting. Repeatedly clicking or reopening the file during a calculation can make it harder to tell what happened.

Start with safe checks and a copy

Before changing settings, preserve the file and check whether the issue is reproducible. If the workbook opens, use File > Save As to make a separate troubleshooting copy. If it will not open, copy the file in File Explorer before trying repair steps. For a file stored in OneDrive, SharePoint, or a network folder, keep a local copy as well; this helps distinguish a workbook problem from a sync or connection problem.

  • Open a different workbook, such as a new blank workbook. If that also crashes, investigate Excel or the computer rather than focusing only on the original file.
  • Try the affected workbook on another trusted computer, if available. If it crashes there too, the file is a stronger suspect.
  • Write down the action that triggers the failure, any error message, and whether Excel closes or merely stops responding.
  • Restart Windows and install available Office updates before repeating the same test. A restart can also clear a temporary system-resource issue.

Do not overwrite the only copy with a repaired or resaved version until you have checked the result. Repair attempts and format conversions can alter workbook content, and a backup gives you a way to compare or recover information.

Test Excel in Safe Mode

On Windows, Safe Mode starts Excel without some startup files and add-ins. It is a useful diagnostic test, not a permanent operating mode. Close Excel, press Windows key + R, type excel /safe, and press Enter. If Excel opens, try the same workbook. If the crash no longer occurs, an add-in or startup customization becomes a likely cause.

To check add-ins, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then choose Go. Clear the check boxes and restart Excel normally. If the problem stops, enable add-ins one at a time, restarting and testing after each change. This identifies a likely conflict more reliably than disabling several items and guessing.

Also inspect Excel Add-ins in the Manage list; these are a separate category from COM Add-ins. An add-in may be needed for a workplace workflow, so note its name before turning it off and ask the relevant administrator or vendor if it appears essential. If Safe Mode does not help, restore any settings you changed and continue with workbook-specific checks.

The Run command above is for Windows, not Mac. On a Mac, test with add-ins disabled using the add-in controls available in that Excel version; the Tools menu may include Excel Add-ins. Avoid applying Windows COM Add-in instructions to Mac, because the available add-in types and menu paths differ.

When only one workbook crashes

If other files work, try opening the problem workbook through Excel’s repair option. In Excel for Microsoft 365 on Windows, choose File > Open > Browse. Select the file, open the arrow beside the Open button, and choose Open and Repair. Try Repair first. If that does not work, Excel may offer Extract Data, which attempts to recover values and formulas; it may not preserve every feature or layout.

If you can open the file long enough to work, make a copy and test likely trouble spots one at a time. Examples include a sheet with many formulas, a recently added chart, a pivot table, a data connection, or a conditional-formatting rule applied to an entire column. Removing or changing one item in a copy can show whether it is associated with the crash. Do not delete content from the original as a first test.

External links and refreshable data can cause problems when a source is unavailable or the connection is unstable. If the workbook crashes during refresh, test a copy without refreshing, or ask its owner what sources it uses. Do not break links or remove queries unless you understand the consequences: reports may stop updating, and linked values can become static.

File format matters too. A CSV file stores plain text data, not Excel features such as multiple sheets, formulas, charts, or formatting. Saving a workbook as CSV is therefore not a general repair method. If you need to test a simpler file, make a separate copy and choose a format appropriate to the content you need to preserve.

Check calculation load, workbook size, and memory

A workbook with extensive formulas, many volatile calculations, large data ranges, complex formatting, or frequent data refreshes can take substantial time and memory. Excel may become unresponsive during recalculation even when the file is not damaged. Check whether the crash happens after a particular edit or when calculation begins, and compare behavior with a smaller copy of the workbook.

One useful test is to open a copy and change calculation to manual using Formulas > Calculation Options > Manual. This can prevent repeated recalculation while you inspect the workbook, but it also means formula results may not update until you calculate. Treat it as a diagnostic measure, and restore Automatic calculation when appropriate. A workbook saved in manual mode can affect calculation behavior in other open workbooks, so tell colleagues if you share it in that state.

Large files can also expose limits in the computer’s available memory. Close other demanding applications and check that the system has free disk space. Excel’s 32-bit and 64-bit editions differ in how much memory they can address; 64-bit Office can use more memory for large workbooks, but compatibility with older add-ins or connected software should be checked before changing Office architecture. A bigger computer is not automatically the fix if the actual cause is a faulty add-in or damaged file.

Update or repair Microsoft 365

Install Office updates from File > Account > Update Options > Update Now in Excel for Windows. If Excel is crashing before you can reach that screen, update Microsoft 365 through the account or installation method used on the computer, or ask the organization’s administrator. Updates can include fixes, but they do not guarantee that every workbook issue will disappear.

If Excel crashes with multiple workbooks and Safe Mode did not identify an add-in, repair Office. In Windows, open Settings > Apps > Installed apps, find Microsoft 365, choose its more-options menu, then Modify. The exact labels can vary slightly by Windows build and installation. Quick Repair is the less extensive option; if it does not help, Online Repair is a more thorough repair and may require an internet connection and sign-in afterward. Save work and close Office apps first.

If the computer is managed by an employer or school, check with IT before repairing Office or changing add-ins. Policies, licensed software, and business extensions may be centrally managed. For a crash that began after installing a particular add-in or update, include that timing in a support request rather than repeatedly reinstalling Office.

Recover work and reduce the chance of another crash

After an unexpected close, reopen Excel and look for the Document Recovery pane. It may display recovered versions, but recovery is not guaranteed and a recovered copy may not include the last changes. You can also check File > Info for workbook-management options, including version or unsaved-workbook recovery where available. The choices shown depend on whether the file was saved and how it was stored.

AutoRecover is helpful but is not a substitute for saving. In Excel for Windows, review File > Options > Save for AutoRecover settings. For files saved to OneDrive or SharePoint, AutoSave and version history may offer additional ways to return to an earlier version, depending on the account and location. Keep a separate backup before major edits, especially when the workbook is business-critical.

  • Save at sensible intervals and use a clear filename when creating a troubleshooting copy.
  • Keep Office and legitimate add-ins current, but change one add-in at a time when diagnosing a crash.
  • Remove obsolete external links, unused formatting, and redundant data only after checking what depends on them.
  • Use a trusted local copy to test files that normally open from a network or cloud location.
  • Do not enable macros or other active content in an unfamiliar workbook simply to see whether it opens; confirm its source first.

Frequently Asked Questions

Why does Excel keep crashing when I open one file?
If other workbooks open normally, the affected file may contain damaged content, complex calculations, an unavailable connection, or a feature that triggers a problem. Make a copy and try File > Open > Browse > Open and Repair. Test a local copy and avoid changing the only original.

Can an Excel add-in make a worksheet crash?
Yes. An incompatible or faulty add-in can affect Excel or a particular workbook. On Windows, compare normal startup with excel /safe, then disable COM Add-ins or Excel Add-ins and re-enable them individually. Safe Mode is a diagnostic clue, not proof of which add-in is responsible.

What should I do if Excel freezes but does not close?
Wait briefly if Excel is calculating, refreshing data, or handling a large file. Check for signs of ongoing activity and avoid repeatedly clicking. If it remains unresponsive, use Task Manager only as a last resort, since unsaved changes may be lost; then reopen Excel and check for recovered work.

Will Open and Repair recover everything?
No. It may repair a workbook or extract some data, but it cannot promise to restore every formula, chart, format, connection, or other feature. Work on a copy, compare the recovered file with the original, and keep any available earlier versions.

Does Excel for the web fix a crashing workbook?
It can help determine whether the issue is limited to the desktop installation, but it is not a universal repair. Excel for the web has feature and editing differences, and a damaged or resource-intensive workbook may still have problems. Use it only with a backed-up copy and verify important results in desktop Excel.

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.