Excel Stuck on Not Responding? Causes, Fixes, and Recovery

Errors & fixes · Updated November 21, 2026

If Excel is stuck on Not Responding, first give it a few minutes if it may be calculating, refreshing data, or opening a large file; then try to save if it becomes responsive. If it stays frozen, use the steps below to check for a slow task, an add-in, or a damaged workbook, and recover the latest available copy before troubleshooting further.

What Not Responding means

In Windows, Not Responding is a status that indicates Excel is not answering Windows messages promptly. It does not, by itself, prove that Excel has crashed or that the workbook is lost. Excel may be busy with a calculation, a large import, an external connection, a macro, or another operation that temporarily prevents it from updating the window.

A brief pause is common when a workbook contains many formulas, a large PivotTable, extensive formatting, or connections to slow files and services. A freeze that lasts many minutes, repeats every time you open one particular workbook, or occurs even with a blank workbook is more suggestive of a persistent problem. The cause matters: closing Excel immediately can discard unsaved changes, while waiting indefinitely may not help if an add-in or workbook has stopped responding.

Before closing anything, look for signs of activity. Excel may show progress, the mouse pointer may indicate work, or the computer may be using substantial processor or disk resources. Those signs are not proof that a task will finish, but they can help distinguish a busy workbook from an application that is no longer making progress.

What to do first without losing work

  1. Wait briefly. If you just opened a large file, ran a calculation, or refreshed a query, give Excel time to finish. Repeatedly clicking the window can make it harder to tell whether it has recovered.
  2. Check whether another dialog is waiting. Press Alt+Tab on Windows to look for a file prompt, security warning, or other Excel window hidden behind the main workbook. A dialog can make the workbook appear stuck. On Mac, use Command+Tab to switch apps and check for an Excel dialog.
  3. Try to save if Excel responds. On Windows, press Ctrl+S; on Mac, press Command+S. If the window becomes usable, save a new copy with File > Save As before running more experiments.
  4. Check system activity before ending the task. On Windows, press Ctrl+Shift+Esc to open Task Manager and inspect Excel’s activity. On Mac, open Activity Monitor from Applications > Utilities. Resource use can suggest Excel is still working, but do not treat it as a guarantee that the workbook is safe.

If Excel remains unresponsive and you have no way to save, you may have to close it. On Windows, use Task Manager to select Microsoft Excel and choose End task. On Mac, press Option+Command+Esc, select Excel, and choose Force Quit. These steps can lose changes made since the last save or recovery point, so use them only when waiting and checking for a hidden dialog have not helped.

Recover unsaved changes

After Excel closes unexpectedly, reopen it and check the Document Recovery pane if it appears. Open the version with the latest time, review it, and save it under a new name. Recovery may not include every last edit; it depends on when Excel last saved recovery information and whether the file had been saved before.

For a workbook that was never saved, use File > Info > Manage Workbook > Recover Unsaved Workbooks, if that option is available. For an existing workbook, check File > Info for versions or recovery copies. The exact options can vary with the file’s location and Microsoft 365 setup. If the workbook is stored in OneDrive or SharePoint and AutoSave is on, check its version history as another way to locate an earlier saved version.

To review AutoRecover settings in Excel for Microsoft 365 on Windows, go to File > Options > Save. Check whether Save AutoRecover information every… is enabled and note the interval and recovery-file location. AutoRecover is a safety net, not a substitute for saving: it may not capture the most recent work, and it cannot guarantee recovery after every kind of failure. For cloud files, AutoSave can save changes as you work, but it depends on the file being in a supported cloud location and connected as expected.

Check whether the problem is Excel-wide or file-specific

Once you have protected any recoverable work, test Excel with a blank workbook. If a blank workbook works normally but one file repeatedly freezes, focus on that file: its formulas, formatting, connections, macros, or structure may be responsible. If even a blank workbook is slow, investigate add-ins, the Office installation, updates, or the computer’s resources.

To make a simple comparison, close other workbooks if Excel will let you, then create a blank workbook with Ctrl+N on Windows or Command+N on Mac. Avoid opening the problem workbook repeatedly before making a copy. If possible, save a separate troubleshooting copy and use that for experiments; changes such as removing formulas or connections can alter the workbook’s results.

Notice when the freeze begins. A pause while opening can point to links, startup files, or workbook content. A pause after choosing Data > Refresh All points toward a query or connection. A freeze after editing a cell may involve recalculation or conditional formatting. A freeze that occurs only when a specific command runs may involve a macro or add-in. These patterns narrow the search, although they do not identify the cause on their own.

Start Excel in Safe Mode and test add-ins

Excel Safe Mode starts the Windows desktop app with some startup features bypassed, which can help determine whether a customization is involved. Close Excel, press Windows key+R, type excel /safe, and press Enter. If Excel works in Safe Mode but freezes during a normal start, an add-in or another startup component becomes a useful suspect. Safe Mode is a diagnostic comparison, not a repair of the workbook.

To test COM add-ins in the normal Windows app, open File > Options > Add-ins. At the bottom, set Manage to COM Add-ins and select Go. Clear the check boxes to disable the listed add-ins, select OK, and restart Excel normally. If the freezing stops, enable add-ins one at a time, restarting and checking after each change, to identify whether one is involved. You can re-enable the others afterward.

Excel add-ins are managed separately: in the same Add-ins screen, choose Excel Add-ins in the Manage list and select Go. Disable these only as a test, then restore the ones you need. Menu labels and available add-ins can vary. Excel for Mac does not use the Windows excel /safe launch command or the same COM Add-ins controls; check the add-in’s settings in Excel for Mac and disable it there if the option is available.

Workbook causes: formulas, data, and macros

Some workbooks genuinely require significant processing. Large ranges referenced by formulas, repeated volatile calculations, complex conditional formatting, or many linked workbooks can increase calculation time. A workbook that recalculates after every change may seem frozen while Excel updates dependent results. If it eventually responds, inspect the workbook’s design and consider simplifying unnecessarily broad ranges or reducing duplicate calculations.

External data can also take time. A query may be waiting for a server, a file may be on a slow or disconnected network location, or a PivotTable may be refreshing a large data source. If the freeze starts during a refresh, note which connection or query is running before cancelling it. Cancelling a refresh can leave data out of date; it does not necessarily mean the workbook itself is broken.

A macro can make Excel appear unresponsive while it runs, especially if it processes many rows or performs repeated updates. Do not keep clicking its button. If the workbook came from an unfamiliar source, avoid enabling macros unless you trust the source and understand why the code is needed. If a macro regularly causes freezes, ask its owner or a qualified support person to review it rather than running unknown code repeatedly.

For a workbook that opens but remains slow, try working on a copy and remove or adjust only one suspected feature at a time. For example, compare a copy with external connections disabled against the original, or test a copy after reducing excessive formatting. This makes it easier to identify the trigger and restore the original if a change affects results.

Repair the workbook, Office, or Windows setup

If one workbook may be damaged, first make a copy of the file. In Excel for Windows, go to File > Open > Browse, select the workbook, choose the arrow beside Open, and select Open and Repair. If Excel offers a repair, review the result carefully: repaired files can have content removed or changed. If the file is on a network or cloud drive, also try a local copy, provided you can do so safely and have permission.

If many workbooks freeze, check for Microsoft 365 updates: open Excel and choose File > Account > Update Options > Update Now. If Excel itself is too unstable to do that, use the available Office update method for your Windows installation. A Windows restart may also clear a temporary system-level issue, but save other open work first.

On Windows, Office repair is available through the installed apps settings. Open Windows Settings, go to Apps > Installed apps, select Microsoft 365 or Office, choose Modify, and follow the repair options shown. The exact labels can differ by Windows version and installation type. A Quick Repair is a reasonable first attempt; an Online Repair is more thorough and may take longer or require internet access. On Mac, use Microsoft’s current Office update and support guidance rather than Windows repair controls, which do not apply.

Prevent Excel from freezing again

  • Save regularly with Ctrl+S on Windows or Command+S on Mac, and keep a separate backup of important workbooks.
  • Use OneDrive or SharePoint AutoSave when appropriate, and check that the file has finished syncing before relying on a cloud copy.
  • Keep Microsoft 365 and trusted add-ins updated. Remove or disable add-ins that are no longer needed.
  • Refresh external data deliberately, especially in large workbooks, and avoid starting multiple expensive operations at once.
  • Keep formulas and formatting limited to the data they need to cover. Very broad ranges can make some workbook operations heavier than necessary.
  • For a critical workbook, keep an untouched backup before changing connections, calculation settings, macros, or structure.

Changing calculation mode to Manual is sometimes suggested as a speed workaround, but it has a trade-off: formula results may remain out of date until recalculated. If you choose to test it after the workbook is responsive, use Formulas > Calculation Options > Manual and remember to calculate results when needed. Calculation mode can affect other open workbooks, so restore Automatic when the test is over unless you have a deliberate reason to keep Manual.

Frequently Asked Questions

Should I wait or force close Excel?
Wait if a calculation, refresh, or large file operation may still be running, and check for a hidden dialog. If Excel remains unresponsive for a long time with no sign of progress, force-closing may be necessary, but unsaved changes can be lost. Check recovery options after reopening.

Why does Excel say Not Responding when opening one file?
That workbook may contain heavy calculations, external links, data connections, macros, extensive formatting, or damaged content. Test a blank workbook and a separate copy of the affected file to see whether the problem follows that workbook.

Will I lose my work if I end Excel in Task Manager?
You can lose changes that were not saved or captured by AutoRecover. After restarting Excel, look for Document Recovery, Recover Unsaved Workbooks, or a suitable cloud version history. Recovery is not guaranteed to include the latest edits.

How do I open Excel in Safe Mode?
On Windows, close Excel, press Windows key+R, enter excel /safe, and press Enter. This is a Windows desktop-app method; it is not the same command for Excel for Mac or Excel for the web.

Does Not Responding mean my workbook is corrupted?
No. It can mean Excel is busy or waiting, and the status alone does not diagnose file damage. If only one workbook consistently causes the issue, make a backup and consider Open and Repair; if every workbook does it, investigate Excel-wide causes first.

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.