Excel Not Responding: Should You Wait or Force Quit?

If Excel says Not Responding, wait briefly if the workbook may be calculating, refreshing data, or saving; do not immediately force-quit it. If there is no sign of progress after several minutes and Excel remains unresponsive, try to protect your work and then close the app only as a last resort. There is no single wait time that fits every workbook.

How long should you wait?

Give Excel at least a minute or two before deciding that it is stuck, especially after opening a large workbook or running a calculation-heavy task. A complex file can take considerably longer. Workbooks with many formulas, large data sets, external connections, or macros may keep Excel busy for several minutes, and a slow computer can add to that time.

Consider what you asked Excel to do. Recalculating formulas after changing a cell, refreshing a Power Query connection, sorting a large table, opening a file over a network, or saving a workbook with many images can all take time. If you recently started one of these tasks, waiting longer is often safer than interrupting it. Repeatedly clicking the window or pressing keys usually does not make the work finish sooner and can queue up extra actions for Excel to handle later.

Use the computer’s activity as a clue, not a stopwatch. If Excel is using processor time or the disk is active, it may still be working. If it has shown no meaningful activity for a long period, the window stays unresponsive, and the task was small, it may be genuinely hung. These clues are not proof: a program can be busy without obvious activity, and another process can account for computer usage. For a routine workbook, several minutes with no progress is a reasonable point to investigate rather than wait indefinitely.

Why Excel can appear frozen

Windows may label Excel Not Responding when the app is not responding to window messages promptly. That does not necessarily mean the workbook is damaged or that Excel has stopped all work. A long-running calculation or operation can temporarily prevent the interface from responding, making a busy program look like a crashed one.

Common causes include a large or complicated workbook, formulas that trigger extensive recalculation, an add-in, a macro, an external data refresh, or a file stored on a slow or interrupted network location. Low available memory or heavy activity from other apps can also contribute. A workbook with many volatile formulas, such as formulas that recalculate frequently, may take longer to update than a smaller file with simpler calculations.

Excel may also appear unresponsive while waiting for another application or a connection. For example, a workbook linked to external data may be waiting for a source to respond. Closing Excel in the middle of a refresh can interrupt the operation; it does not necessarily fix the underlying connection problem. The cause matters because the best response to a slow refresh is different from the response to a one-cell edit that has left a small workbook idle for a long time.

Clues that Excel is still working

Before ending the task, look for signs that the current operation is progressing. You may not be able to interact with the worksheet itself, so check the app and computer without repeatedly clicking Excel.

The status bar changes: messages such as Calculating or progress information can indicate that Excel is processing work. A message that stays unchanged does not prove Excel is frozen, but changing progress is a good reason to keep waiting.
Computer activity continues: In Windows, press Ctrl+Shift+Esc to open Task Manager and look at Excel’s CPU and disk activity. The Mac equivalent for opening Force Quit is Option+Command+Esc, though it is not a direct equivalent to Windows Task Manager.
The task is known to be demanding: A large refresh, complex calculation, or macro can take longer than an ordinary edit. Allow extra time if you intentionally started such a task.
The window briefly responds: If the worksheet or status information updates, or the app becomes responsive again, let the operation complete before starting another one.

Task Manager is useful for observation, not for diagnosing the workbook with certainty. Avoid ending Excel from Task Manager while there is a reasonable chance it is calculating or saving. Also avoid launching another copy of the same workbook to see whether it opens; that can add confusion about which copy contains the latest changes.

What to do before force-closing Excel

Start with low-risk checks. Wait, note what operation was underway, and check whether Excel’s status or the computer’s activity changes. If Excel becomes responsive, save a new copy before continuing with troubleshooting. In Excel for Microsoft 365 on Windows, use File > Save As to save a copy with a different name or in a different location. This gives you a fallback if the original workbook later behaves unpredictably.

If the problem started during a connection refresh, allow time for it to finish if possible. If it was a macro, be particularly cautious: a macro may have changed data or files before Excel stopped responding. Force-closing does not undo those external changes. If the computer itself is slow, close other applications only if they respond normally; do not restart Windows as the first response to an Excel freeze.

Do not repeatedly click the worksheet, press Save, or open extra copies while Excel is unresponsive.
If Excel recovers, save the workbook under a new name and check the affected sheets and data.
If Excel is still unresponsive after a reasonable wait, close it once and allow Windows time to process the request.
Use Task Manager to end the Excel task only if the normal close attempt fails and you accept that unsaved changes may be lost.

There is no reliable way to force-save a workbook from an Excel window that cannot respond. If the work was never saved, recovery features may help, but they are not a substitute for a saved copy. The safest decision depends on the value of the unsaved work and the evidence that Excel is still active.

What may be recoverable after closing

Excel has AutoRecover features that can preserve recovery information at intervals. On Windows, check File > Options > Save for AutoRecover settings, including the interval and the option to keep the last AutoRecovered version if you close without saving. The exact files available after a crash depend on the settings and when Excel last created recovery information, so recovery is not guaranteed to include your most recent edits.

After Excel restarts, a Document Recovery pane may appear with available versions. Review the date and time, open the version that appears most useful, and save it under a new name before replacing anything. You can also check File > Info for workbook management and recovery options, or File > Open > Recent for the Recover Unsaved Workbooks option when it is available.

AutoSave is different from AutoRecover. AutoSave can save changes continuously for supported files stored on OneDrive or SharePoint when it is enabled, but it is not a promise that every operation or the latest state will be preserved in every failure. For cloud files, version history may offer an earlier copy to restore or inspect. For a file saved only on the computer, check the local recovery options instead. If you recover a version, compare important formulas and recent entries before treating it as complete.

How to reduce repeat freezes

If the same workbook repeatedly causes Excel to stop responding, troubleshoot the pattern rather than force-closing it every time. First note whether the problem occurs when opening the file, editing particular cells, refreshing data, saving, or running a macro. A repeatable trigger narrows down the likely cause and helps distinguish a workbook issue from a broader Excel or computer problem.

Test Excel without add-ins: Close Excel, then use the Windows Run dialog to start excel /safe. If the problem does not occur in Safe Mode, an add-in or customization may be involved. This is a diagnostic clue, not a fix by itself.
Review add-ins: In normal Excel, open File > Options > Add-ins. At the bottom, choose the relevant add-in type in the Manage box and select Go to review enabled items. Disable only an item you can safely test, then restart Excel and check whether the issue returns.
Check the file and its location: If the workbook is on a network or cloud location, test whether the connection is stable and whether a local copy behaves differently. Keep the original unchanged while testing.
Reduce unnecessary work: Close unrelated applications, avoid refreshing several sources at once, and consider whether the workbook has become much larger or more formula-intensive than before.
Keep backups: Save important work regularly and retain separate copies before major edits, data imports, or macro runs.

Safe Mode and add-in tests are for Windows desktop Excel. Excel for the web does not use the same Windows startup procedure, and Excel for Mac has different menus and startup behavior. If the freeze happens in only one file, investigate that workbook and its connections; if it happens across many files, investigate Excel, add-ins, or the computer more broadly.

When should you force-quit?

Force-quit when Excel remains unresponsive after a reasonable wait, there is no convincing sign of progress, a normal close does not work, and you are prepared to lose changes made since the last successful save or recovery point. On Windows, try closing the Excel window normally first. If it will not close, use Ctrl+Shift+Esc, select Microsoft Excel in Task Manager, and choose End task. The labels can vary slightly by Windows version.

On a Mac, use Option+Command+Esc to open the Force Quit Applications window, select Microsoft Excel, and choose Force Quit. As on Windows, unsaved work can be lost. After reopening Excel, inspect any recovery versions before continuing. Do not assume that force-quitting will repair a workbook; if the issue recurs, address the underlying trigger or make a clean copy and troubleshoot that copy.

Frequently Asked Questions

How long should I wait when Excel says Not Responding?
Start with a minute or two, then allow longer for a large calculation, refresh, or save. If there is no progress or activity for several minutes on a simple task, investigate and consider closing Excel rather than waiting indefinitely.

Will I lose my work if I force-quit Excel?
You may lose changes made since the last save or recovery point. AutoRecover, Document Recovery, AutoSave, or cloud version history may provide a newer copy, but none should be treated as guaranteed. Save a separate copy as soon as Excel responds again.

Is Excel frozen if Task Manager says Not Responding?
Not necessarily. Windows can show that label when Excel is not processing window messages promptly, including during a long operation. Check for signs of activity and consider what Excel was doing before ending the task.

Can I save while Excel is not responding?
Usually you cannot reliably save from an interface that is not responding. Wait to see if Excel recovers; if it does, save immediately, preferably as a new copy. Recovery features may help if it does not recover, but they may not contain the latest edits.

Why does Excel keep freezing on one workbook?
A particular workbook may involve heavy formulas, large data, external connections, macros, or an add-in interaction. Note what action triggers the freeze, test a copy carefully, and check whether Excel behaves differently in Safe Mode on Windows.

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.