Excel Spreadsheet Not Responding? Causes and Fixes

How-to basics · Updated November 21, 2026

If an Excel spreadsheet is not responding, first stop clicking and give it a few minutes: a large calculation, refresh, or save may still be running. If it remains frozen, try to save with Ctrl+S; if Excel will not recover, close it through Task Manager and reopen it, then check Document Recovery before continuing. The safest next step depends on whether Excel itself is stuck or one workbook is causing the problem.

What “Not Responding” Means

In Windows, “Not Responding” usually means Excel has stopped replying to Windows while it works, waits on another component, or encounters a problem. It does not prove that the workbook is lost or that Excel has crashed permanently. For example, recalculating formulas across a large workbook can temporarily make the window look frozen even though Excel is still processing.

Look for clues before forcing Excel to close. Is the status bar showing a calculation or refresh? Is the workbook stored in a synced folder and currently saving? Does the problem happen only after opening one specific file, or even when Excel starts with a blank workbook? These distinctions help separate a slow operation from a damaged file, a troublesome add-in, or an issue with the Office installation.

Repeatedly clicking the ribbon or opening more copies of Excel is rarely helpful. It can queue actions or make it harder to tell which window is working. If you have just started a demanding action, allow time for it to finish, especially on a computer with limited memory or when the file contains many formulas, charts, or data connections.

Recover Work Before Troubleshooting

If Excel becomes responsive again, save immediately with Ctrl+S. On a Mac, use Command+S. If the workbook is important, save a separate copy with File > Save As before testing changes. This preserves an untouched version in case a repair or a change to formulas affects the contents.

If the application will not recover after a reasonable wait, use Task Manager on Windows: press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This can discard unsaved changes, so use it only when waiting and attempting to save have failed. When Excel starts again, look for the Document Recovery pane and open the newest recovered version. Save it under a new name rather than assuming every last edit was restored.

AutoRecover can help restore work after an unexpected close, but it is not a guaranteed substitute for saving. Its availability and recovery point depend on Excel’s settings and when the last recoverable copy was created. If a recovered file opens, compare it with the last saved version and check important sheets, formulas, and recent edits.

For future protection, review File > Options > Save in Excel for Windows. There you can check AutoRecover settings and the location used for AutoRecover files. The precise settings may vary with the installed Microsoft 365 build or organizational policies. Saving routinely, and keeping a separate copy before risky edits, remains the most dependable safeguard.

Find Out Whether the Workbook or Excel Is at Fault

After reopening Excel, test a blank workbook. If that works normally but the original file freezes, focus on that workbook: it may contain expensive formulas, a problematic connection, extensive formatting, or file damage. If even a blank workbook hangs, investigate Excel itself, its add-ins, updates, or the computer environment.

On Windows, start Excel in safe mode to check whether add-ins or startup customizations are involved. Press Windows key+R, type excel /safe, and press Enter. If Excel behaves normally in safe mode, an add-in or startup item is a likely cause, though the test does not identify which one. Open the affected workbook only after Excel has launched.

To inspect add-ins in normal Excel, go to File > Options > Add-ins. At the bottom, choose COM Add-ins from the Manage list and select Go. Clear a selected add-in to disable it temporarily, restart Excel, and see whether the problem returns. You can also inspect Excel Add-ins through the same Manage list. Disable one at a time and test; turning off all add-ins at once may hide the specific cause. Menu labels or available add-ins can differ by installation.

On a Mac, Windows safe-mode commands and Task Manager do not apply. To close an unresponsive app, press Option+Command+Esc, select Excel, and choose Force Quit. Restart Excel and test a blank workbook. If the issue persists, check available Microsoft 365 updates and isolate any add-ins using Excel’s add-in controls; their exact location can vary by Excel for Mac release.

Common Workbook Triggers

A workbook can make Excel appear stuck because one operation requires substantial processing. Common examples include formulas that refer to very large ranges, many volatile formulas that recalculate frequently, extensive conditional formatting, complex pivot tables, or external data connections that are slow or unavailable. A workbook with lots of pictures, charts, or embedded objects can also take longer to open and save.

Consider a monthly report that imports several large data tables, applies formatting to entire columns, and contains formulas that depend on those tables. Opening it may trigger data refreshes and recalculation at the same time. If the workbook eventually finishes, note which action preceded the freeze: opening, filtering, refreshing, editing a formula, or saving. Repeating that same action in a copy can help narrow down the cause without putting the original at risk.

External links and connections are another source of delay. A workbook may try to reach a network location, database, or source file that is slow or inaccessible. If Excel asks whether to update links, do not accept or reject automatically without considering what the workbook needs. If the data is meant to be current, confirm that the source is available; if not, work on a copy and investigate the workbook’s connections before removing or changing them.

File size alone does not diagnose the problem. A large workbook can work well, while a smaller file can hang because of a damaged object, a slow connection, or a calculation pattern. Compare behavior in a copy and use Excel’s built-in workbook features cautiously; deleting sheets, links, or formatting merely to make a file smaller can remove information the workbook needs.

Check Calculation, Updates, and File Repair

If the freeze follows formula edits or opening a calculation-heavy workbook, check Formulas > Calculation Options. Automatic calculation is the usual setting. Manual calculation can make some large workbooks more responsive while you edit, but it means formulas may show old results until recalculated. Treat it as a temporary diagnostic or a deliberate workflow choice, not a universal repair. Press F9 on Windows to calculate open workbooks; Shift+F9 calculates the active worksheet. Keyboard behavior can differ on Mac keyboards, where function-key settings may affect the keys.

Install available Office updates in Excel for Windows through File > Account > Update Options > Update Now. Updates can address application problems, although they are not guaranteed to resolve a particular workbook issue. In Excel for Mac, use Help > Check for Updates if Microsoft AutoUpdate is available, or check the update method provided for your Office installation.

If one file repeatedly fails to open, make a copy first. In Excel for Windows, choose File > Open > Browse, select the copy, then use the arrow beside the Open button and choose Open and Repair. If Excel offers repair or data extraction options, review the result carefully and save any recovered contents under a new filename. Open and Repair may not restore every feature or all data, and the menu path may differ in other Excel versions.

If safe mode, updates, and workbook-specific checks do not help, repair Microsoft 365 from Windows Settings. Depending on the Windows version, find Microsoft 365 under Apps or Installed apps, open its options, and choose Modify. Quick Repair is the less extensive first option; Online Repair is more comprehensive and may require an internet connection and sign-in afterward. Save work and close Office apps before starting. Organizational devices may require an administrator to perform repairs.

Prevent the Freeze From Returning

Once Excel opens normally, make a copy of the workbook and change one thing at a time. If you suspect formulas, test whether a smaller calculation range improves the copy. If the issue follows a refresh, test with the source accessible and review the connection settings. If disabling one add-in resolves the freeze, check with its provider or your organization before removing it permanently, especially if the add-in supports business workflows.

  • Save before refreshing data, changing calculation settings, or making broad workbook edits.
  • Close other large applications if the computer is low on available memory.
  • Keep Excel and the workbook on a stable, accessible storage location while saving or refreshing.
  • Avoid applying complex formatting to entire rows or columns when only a smaller data range needs it.
  • Keep a clean backup before using Open and Repair or changing connections, formulas, and add-ins.

For a workbook shared through OneDrive or SharePoint, check whether it is still syncing and whether another person is editing it. A sync delay is not the same as an Excel crash. Let synchronization finish where possible, and avoid closing Excel during an active save. Excel for the web runs in a browser, so browser tab problems and desktop Excel problems require different troubleshooting; the Windows safe-mode command applies to the desktop application, not Excel for the web.

Frequently Asked Questions

Should I wait or force close Excel? Wait if Excel has just started a calculation, refresh, or save, and avoid repeated clicks. If it remains unresponsive and you cannot save, end the task as a last resort, then check Document Recovery when Excel reopens. Force closing can lose changes made since the last save or recovery point.

How do I recover an unsaved Excel spreadsheet? Reopen Excel after an unexpected close and check the Document Recovery pane. If it does not appear, look under File > Info for workbook-management or recovery options available in your Excel build. Recovery depends on AutoRecover and may not include the latest edits, so save any recovered copy immediately.

Why does Excel freeze only with one file? The workbook may trigger heavy calculations, a slow external connection, extensive formatting, or a file-specific problem. Test a copy, note the action that causes the freeze, and compare it with a blank workbook. Do not delete data or links from the original as an initial test.

Can an Excel add-in cause a spreadsheet to stop responding? Yes. Add-ins can interact with Excel and may be involved when a freeze disappears in safe mode. Disable add-ins one at a time through File > Options > Add-ins on Windows, restart, and retest. If the problem remains in safe mode, an add-in is less likely to be the cause.

Will Open and Repair delete my spreadsheet? It is intended to open or recover a damaged workbook, but the result is not guaranteed and some content may be missing. Use it on a copy and save the recovered file under a different name. Keep the original untouched until you have checked the repair.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.