Excel Not Responding and Won’t Close? Try These Fixes

If Excel says Not Responding and will not close, first give it a minute if it may be calculating or opening a large file; then try Esc and save if the window responds. If it remains frozen, press Ctrl+Shift+Esc, select Microsoft Excel in Task Manager, and choose End task—this forces Excel to close, so unsaved changes may be lost.

Decide whether Excel is busy or truly stuck

Not Responding is a Windows status, not a diagnosis. Excel may temporarily stop updating its window while it performs a calculation, loads data, refreshes a connection, or waits for another application. A busy workbook can look frozen even when Excel is still working. If you have just opened a large workbook or started a calculation, wait briefly before ending the task.

Look for signs of activity. In Task Manager, opened with Ctrl+Shift+Esc, Excel’s CPU usage may rise and fall while it calculates. Disk activity may also indicate that it is reading or saving a large file. These clues are not guarantees: a frozen application can still use resources, and a busy calculation may take longer than expected. If there is no visible progress and Excel does not respond after a reasonable wait, move on to a controlled close.

Before forcing it to quit, try the following:

Press Esc once to cancel a dialog, selection, or operation that can be interrupted. For a calculation that appears stuck, Ctrl+Break may interrupt it on many Windows keyboards; some compact keyboards require an Fn key. This is not a general-purpose close command.
Press Alt+Tab to check for a hidden message box or prompt behind the workbook. Excel may be waiting for a choice, such as whether to update links or confirm a file format.
If the workbook becomes responsive, press Ctrl+S and wait for saving to finish before closing it.

Force Excel to close in Windows

If Excel remains unresponsive, use Task Manager rather than repeatedly clicking the close button. Press Ctrl+Shift+Esc, select Microsoft Excel under Processes, and choose End task. In some Windows layouts, you may need to expand the Apps or Processes list to locate it. If several Excel windows are open, check which process or workbook you are ending; ending Excel can close all workbooks handled by that process, not just the visible one.

Use End task only when waiting and basic keyboard checks have failed. Excel cannot save changes after it has been terminated, and recovery is not guaranteed. Avoid ending unrelated processes in Task Manager. If Task Manager itself will not open or Windows is unresponsive, restart the computer as a last resort; a forced restart can lose unsaved work in other applications too.

After Excel closes, wait a few seconds before reopening it. If Windows reports that Excel is still running, check Task Manager again. Do not repeatedly start new copies while an earlier process is still shutting down: multiple instances can make it harder to tell which window has the file and may increase resource use.

Recover work after an unexpected close

When Excel starts again after an unexpected shutdown, look for the Document Recovery pane. It may list recovered versions of open workbooks. Open the version with the most recent time, compare it with what you remember, and use Save As to preserve it under a new name before replacing the original. Recovery may contain only changes captured at the last recovery point, not every edit made before the freeze.

If the pane does not appear, check Excel’s unsaved-workbook recovery option: choose File > Info > Manage Workbook > Recover Unsaved Workbooks. The exact available entries depend on whether Excel saved recovery data for that session. If you find a needed file, open it and immediately save a copy to a safe location. For a workbook stored on OneDrive or SharePoint, check its version history as well; cloud version history can provide an earlier saved version, but it does not guarantee recovery of edits that were never synced.

AutoRecover and AutoSave are different. AutoRecover periodically stores recovery information for a crash or unexpected close; its interval and location can be reviewed through File > Options > Save. AutoSave, when available for a workbook stored in OneDrive or SharePoint, saves ongoing changes to the cloud. Neither feature is a substitute for deliberately saving important work, and settings or connectivity can affect what is available.

Start Excel in Safe Mode and check add-ins

If Excel repeatedly freezes, test whether an add-in or startup customization is involved. Close Excel first. Press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the same workbook works normally in Safe Mode, an add-in or startup item is one possible cause, though the test alone does not prove which one.

To check COM add-ins in normal Excel, choose File > Options > Add-ins. At the bottom, next to Manage, choose COM Add-ins and click Go. Clear the check boxes to disable the listed add-ins, then restart Excel normally and test. If the problem stops, re-enable the add-ins one at a time, restarting and testing after each change, to identify whether one consistently triggers the freeze. Excel add-ins can also be managed from the same screen by choosing Excel Add-ins in the Manage list.

Do not remove an add-in permanently just because it is present. Some are required for workplace workflows or connected systems. If Excel is managed by an organization, ask its IT team before changing a required extension. The Safe Mode launch command applies to Excel for Windows; Mac users should not assume that the Windows command or this COM Add-ins path exists on their version.

Common causes of an Excel freeze

A large or demanding workbook is a frequent explanation. Formulas that recalculate across many rows, volatile calculations, extensive conditional formatting, large pivot tables, and data connections can all increase the work Excel must do. External links may also prompt Excel to retrieve or update information. If a workbook freezes during a specific action—such as refreshing a query, opening a sheet, or changing a formula—that timing is useful evidence for narrowing down the cause.

Other possible causes include a damaged workbook, an add-in conflict, limited available memory, an outdated Office installation, or a printer driver that is not responding. Excel may also appear stuck behind a modal dialog. These causes can produce similar symptoms, so use patterns rather than assuming one diagnosis. For example, if only one workbook freezes, its size, formulas, links, or file integrity deserve attention. If several unrelated workbooks freeze, consider an add-in, Office update, system resource, or device-level issue.

Large files stored on a network or synced folder may take longer to open or save when the connection is slow or interrupted. Avoid repeatedly clicking Save during a slow save operation; that can add confusion without making the original operation finish sooner. Check whether the file is available locally or whether a sync client is reporting an error, and coordinate with your organization before moving shared files.

What to do once Excel opens again

First, test whether the issue is limited to one file. Open a blank workbook and perform a simple action. If that works, make a copy of the problem workbook before troubleshooting it. In the copy, try opening with links not updated when prompted, or work on a reduced copy with unnecessary sheets or data removed. Avoid deleting content from the only original: formulas, connections, and workbook structure may depend on it.

If all workbooks are affected, check for Office updates through File > Account > Update Options > Update Now, where that option is available. On managed computers, the organization may control updates. Restart Windows after updates if prompted, then test again. If the problem began after installing a specific add-in or update, note that timing and share it with IT or Microsoft support rather than making broad system changes.

For a workbook that continues to fail, create a copy and try opening it with Excel’s Open dialog. Select File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair if that option is available. Repair attempts can change or remove damaged content, so preserve the original first. If the workbook is on a shared drive, verify that you have permission and that nobody else is saving a conflicting copy.

Differences on a Mac

On a Mac, Excel may show a spinning cursor or stop responding rather than displaying Windows’ exact status. Try waiting, pressing Esc, and saving if the app responds. To force-quit, press Option+Command+Esc, select Microsoft Excel in the Force Quit window, and choose Force Quit. This also risks losing unsaved changes. The Windows Task Manager steps and excel /safe command do not apply to macOS.

After reopening Excel for Mac, check for recovered documents and save any recovered version under a new name. Menu labels and available recovery options can differ by Excel release. If the problem recurs, test a blank workbook, install available Office updates through the app’s update mechanism, and check whether a particular workbook or add-in is responsible. For managed Macs, follow your organization’s support process before removing software or changing settings.

Frequently Asked Questions

Should I wait or force close Excel?
If a calculation, refresh, or save has just started, wait and look for signs of activity. If Excel remains unresponsive, does not show progress, and keyboard checks fail, ending the task is reasonable—but unsaved changes may be lost.

Will Excel recover my unsaved work?
Possibly. Check the Document Recovery pane after restarting, then File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on what Excel captured, so it may not include your latest edits.

Why does Excel freeze only with one workbook?
That points toward something specific to that file, such as heavy calculations, external links, a data connection, or damage. Make a copy before trying repairs or removing content, and compare its behavior with a blank workbook.

Can I close Excel without losing changes?
Only if Excel is responsive enough to save first. Press Ctrl+S and wait for the save to finish. If the program is fully frozen, Windows cannot reliably save the unsaved changes when you force it to close.

Why does Excel keep saying Not Responding?
Recurring freezes can come from a demanding workbook, add-in, resource shortage, network delay, or Office issue. Test Safe Mode and a blank workbook to distinguish workbook-specific symptoms from problems that affect Excel generally.

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.