Excel Not Responding? Close It Safely and Recover Work

How-to basics · Updated November 18, 2026

If Excel says “Not Responding,” first wait briefly if it may be calculating or opening a large file; if it stays frozen, press Ctrl+Shift+Esc, select Microsoft Excel in Task Manager, and choose End task. Force-closing can lose unsaved changes, so reopen Excel afterward and check for Document Recovery or AutoRecover files before continuing.

What “Not Responding” Means

In Windows, “Not Responding” usually means Excel is not currently processing messages from the system interface. It does not, by itself, prove that Excel has crashed or that your workbook is damaged. Excel may be busy recalculating formulas, refreshing data, loading a large workbook, or waiting for a file stored on a network or cloud service. During that work, the window may stop accepting clicks even though the application is still occupied.

The safest response depends on whether Excel is making progress. A short pause is sensible; repeatedly clicking the window, pressing keys, or opening more copies of Excel is not. Those actions can queue up extra commands or make it harder to tell whether the original task has finished. If you can see a calculation indicator, a progress dialog, or activity in the computer’s resource use, give it more time before deciding to end the process.

Try These Steps Before Forcing Excel to Close

Start with simple checks that do not risk discarding the workbook. Wait a minute or two for a routine task, and longer for a very large file or a complex refresh. There is no universal wait time: a workbook with millions of calculations can take longer than a small sheet, while a frozen dialog may not resolve at all. If Excel becomes responsive, save a new copy before investigating further.

  • Check whether a dialog box is hidden behind the workbook or another window. Use Alt+Tab to look through open windows; Excel may be waiting for a prompt about links, printing, or an update.
  • If a calculation or data refresh is visibly progressing, let it finish rather than closing the program mid-task.
  • Try Esc once if Excel appears to be performing a cancellable operation. It may cancel a command, but it will not reliably close an unresponsive application.
  • Do not keep clicking the title bar or the worksheet. If the window remains unresponsive and no progress is apparent, move on to a controlled force-quit.

Alt+F4 is the normal Windows shortcut for closing the active window. If Excel can still receive commands, it may close normally or ask whether to save. When the interface is completely stuck, however, the shortcut may do nothing. On a Mac, Command+Q requests a normal quit, but it also may not work while Excel is frozen.

Force-Close Excel in Windows

Task Manager is the standard way to end a frozen Excel process in Microsoft 365 on Windows. It stops the application rather than performing a normal save, so use it only when waiting and ordinary close commands have failed.

  1. Press Ctrl+Shift+Esc to open Task Manager. If it opens in a compact view, select More details.
  2. On the Processes tab, find Microsoft Excel. If several Excel windows or workbooks are open, note that ending the Excel process can close all of them, not just the workbook that appears frozen.
  3. Select Microsoft Excel, then choose End task. Confirm if Windows asks.
  4. Wait for the process to disappear. Reopen Excel from the Start menu and check for a recovery panel before opening the workbook again.

If Task Manager does not appear, try Ctrl+Alt+Delete and select Task Manager. Avoid restarting the whole computer as the first move: that can interrupt other programs and unsaved work. If Windows itself is unresponsive, a restart may eventually be necessary, but use it only after giving the system time and trying the available recovery options.

Recover Unsaved Changes After Excel Closes

When Excel restarts after an unexpected closure, it may show a Document Recovery pane listing recovered versions. Open the most recent relevant version, compare it with the last saved file, and save the recovered copy under a new name if it contains the changes you need. Do not assume the newest timestamp means every last edit was captured; inspect important sheets and formulas before replacing another copy.

Excel’s AutoRecover feature can preserve recovery information at intervals, but it is not a substitute for saving. If no recovery pane appears, look for Excel’s unsaved-workbook recovery command. In many Microsoft 365 Windows builds, use File > Info > Manage Workbook > Recover Unsaved Workbooks. The precise placement can vary by build; File > Open may also provide a Recover Unsaved Workbooks link. Open any candidate carefully and save it as a separate file.

For a workbook saved to OneDrive or SharePoint, check the file’s version history as well. In Excel, the route can vary with the account and interface, but the workbook name or File area may expose Version History. A previous cloud version may contain work that is absent from the recovered local copy. AutoSave, when available and switched on for a supported cloud file, can save ongoing changes; it cannot guarantee recovery of edits that had not synchronized before the freeze.

If nothing is available, the missing changes may not have been saved or captured by AutoRecover. Recovery depends on settings, timing, storage location, and the point at which Excel stopped responding. Avoid repeatedly opening and overwriting the only copy. Keep any recovered version separate until you have checked its contents.

Why Excel Becomes Unresponsive

A freeze can have several causes, and the right fix depends on whether it affects one workbook or Excel generally. A single large or complicated file may demand substantial time or memory. Common contributors include extensive formulas, volatile calculations, large pivot tables, external data refreshes, linked files that are unavailable, and macros or add-ins that take a long time to run. Printing can also stall while Excel waits for a printer or driver.

If every workbook freezes, consider a broader issue such as an add-in, an Office installation problem, a recent update, or limited system resources. If only one file is affected, its size, contents, links, or location are more likely starting points for investigation. A workbook on a slow network drive or in a syncing folder may also behave differently from a local copy. These are possibilities, not proof of a specific fault; note what action preceded the freeze and whether the same file opens on another occasion.

Test Excel in Safe Mode and Check Add-Ins

Windows Safe Mode starts Excel with many customizations and add-ins disabled, which can help distinguish an add-in problem from a workbook or installation problem. Close Excel first if possible. Press Windows key+R, type excel /safe, and press Enter. If Excel opens and behaves normally in Safe Mode, an add-in or customization is a reasonable next suspect, although the test does not identify which one automatically.

To review add-ins in regular Excel, open File > Options > Add-ins. At the bottom, beside Manage, choose COM Add-ins and select Go. Uncheck an add-in to disable it temporarily, then restart Excel and see whether the problem returns. Excel Add-ins have a separate choice in the Manage list, so check the relevant category if needed. Change one item at a time and keep a note of what you disabled; this makes it easier to identify the cause and restore anything unrelated.

If Safe Mode does not help, avoid assuming that reinstalling Office is the only option. Check for an Office update using File > Account > Update Options > Update Now when Excel can open. If the problem continues across files, Windows’ installed-app settings may offer Microsoft 365 repair options, including Quick Repair. Repair names and locations can vary slightly across Windows versions and installation types. Back up important files before broader troubleshooting.

Reduce the Chance of Another Freeze

Save early and often, especially before refreshing external data, running a macro, or making a large change. For important work, keep a clearly named backup rather than relying on a single working file. If you use a cloud location, confirm that the file has finished syncing before shutting down or disconnecting from the network. AutoSave is useful for supported cloud workbooks, but it should not replace a backup or a quick check that recent edits reached the cloud.

  • Close workbooks and applications you do not need if the computer is low on available memory.
  • Remove or disable add-ins you do not use, and keep essential add-ins updated.
  • Use a local copy to compare performance when a workbook on a shared drive or synced folder is slow; preserve the original and avoid editing two competing copies.
  • For a workbook that repeatedly hangs during calculation, identify expensive formulas or refresh steps, and consider whether the file needs to recalculate everything at once.
  • Keep Windows and Microsoft 365 reasonably current, particularly if the problem began after a system or Office change.

These steps reduce risk but cannot make every workbook immune to a crash. For recurring freezes, record the workbook, operation, error message, and whether Safe Mode changes the behavior. Those details help narrow the cause more effectively than repeatedly force-closing Excel.

Close Excel on a Mac or in a Browser

On a Mac, first try waiting and using the normal quit command, Command+Q. If Excel remains stuck, press Option+Command+Esc to open the Force Quit Applications window, select Microsoft Excel, and choose Force Quit. As on Windows, unsaved changes may be lost. Reopen Excel and check whether a recovered document is offered; recovery is not guaranteed. Mac menu names and recovery locations differ from Windows, so do not rely on Windows Task Manager or Windows ribbon paths on a Mac.

Excel for the web runs inside a browser, so there may not be a separate desktop Excel process to end. If the tab is frozen, give it time, then try reloading only after considering unsaved edits and the file’s cloud-sync status. Closing the browser tab or ending the browser process can discard edits that have not reached the service. If the issue affects only one workbook, try opening it again from OneDrive or SharePoint after confirming the connection; if the whole browser is stuck, use the browser’s own task-management or quit controls.

Frequently Asked Questions

Will I lose my work if I end Excel in Task Manager? Possibly. Anything saved before the freeze should remain in the saved file, but unsaved changes can be lost. AutoRecover or a cloud version may contain some recent work, but neither is guaranteed to capture every edit.

How long should I wait before closing Excel? Wait long enough to rule out an ordinary calculation or refresh. A minute or two is a useful initial pause, not a fixed rule; a large workbook may need longer. If there is no visible progress and Excel remains unresponsive, use Task Manager rather than waiting indefinitely.

Can I close only the frozen workbook instead of all of Excel? If Excel is responsive, close that workbook normally and respond to any save prompt. If the application is fully frozen, ending its process may close every open workbook in that Excel instance, so there is no reliable way to preserve other unsaved windows through Task Manager.

Why does Excel say Not Responding while calculating? Excel may be occupied with a large recalculation, data refresh, or other demanding task and temporarily fail to update its window. The message alone does not establish that the task has failed. If calculation indicators or other signs show progress, give it time; otherwise, investigate the workbook and add-ins after recovery.

Does AutoSave mean I cannot lose changes? No. AutoSave applies to supported files and locations, and changes still need to synchronize. AutoRecover is a separate recovery feature, and its saved information is periodic. Keep backups and check recovered or version-history copies rather than assuming either feature captured the latest edit.

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.