Excel Not Responding: Should You Wait or Close It?

Usually, wait briefly before closing Excel: the Not Responding message means Windows is not receiving a response from the app, but Excel may still be calculating, loading, saving, or working through a large task. Check for signs of activity and give it a few minutes; if there is no progress and the workbook appears idle, try a safe recovery step before ending the task.

What the Not Responding message means

Windows displays Not Responding when an app is not processing messages from the operating system quickly enough. It describes Excel’s responsiveness, not necessarily whether Excel has stopped doing useful work. A workbook can temporarily occupy the program with a calculation, a large import, a complex refresh, or a slow file operation. During that time, the window may be frozen even though the task is continuing.

It is also possible Excel has genuinely stalled, encountered a problematic add-in, or run into a damaged workbook. The message alone cannot distinguish these cases. That is why immediately clicking End task is risky: if Excel is still saving, closing it can interrupt the operation, and unsaved changes may be lost. Waiting forever is not useful either. Look for evidence, then choose a response based on what Excel was doing and how long it has been stuck.

How long should you wait?

There is no universal timeout. A small workbook that was only being edited should normally return quickly, while a workbook with hundreds of thousands of rows, complex formulas, external data connections, or a lengthy macro may take substantially longer. A calculation or data refresh can also take longer on a slower computer or when the source is online.

As a practical first check, wait one or two minutes without repeatedly clicking the window. If the task is substantial, allow several more minutes and look for signs of progress. Five or ten minutes is a useful point to reassess an ordinary operation, not a guaranteed limit: a large refresh or calculation may reasonably take longer. If the task has been unchanged for a long time, the computer is otherwise responsive, and Excel shows no activity, it is more reasonable to investigate or close it.

Repeatedly clicking Excel while it is busy can queue up more requests or make it harder to tell whether anything has changed. Avoid rapidly pressing keyboard shortcuts or opening the same workbook again and again. Give the program a quiet interval, then check Windows Task Manager or the workbook’s status indicators.

Check for signs Excel is still working

Use observable clues rather than relying on the frozen window alone. Press Ctrl+Shift+Esc to open Task Manager on Windows. Find Microsoft Excel in the Processes list and look at whether its CPU or disk activity changes over time. Some activity can indicate ongoing work, although low activity does not prove Excel is frozen; an app can be waiting for a network response or another resource.

Other useful clues include:

What you just asked Excel to do: a large formula recalculation, opening a large file, refreshing a query, or running a macro is more likely to take time than typing into one cell.
The status bar: if Excel becomes responsive enough to show a calculation or refresh message, that can clarify what it is doing.
Computer responsiveness: if other apps and the desktop work normally, the problem may be limited to Excel or that workbook. If the whole computer is slow, memory, storage, or another system-wide issue may be involved.
Visible progress: a changing progress indicator or resource use that rises and falls suggests work may be continuing. Check again after a short interval instead of making a decision from one snapshot.

Do not treat a single Task Manager reading as a verdict. Excel might pause between stages or wait for an external service. Compare activity across a few minutes and consider whether the operation would normally be demanding.

What to try before ending Excel

If the window starts responding, save immediately with Ctrl+S. If the workbook is open from OneDrive or SharePoint and AutoSave is on, check its status rather than assuming every recent edit has already synced. Do not close Excel in the middle of a visible save or upload if you can avoid it.

If you believe Excel is calculating and it responds to keyboard input, press Esc once to try to cancel the current operation. For a calculation or a running VBA macro, Ctrl+Break can interrupt the work in some situations; on keyboards without a Break key, the key combination may require a device-specific Fn key. Interrupting can leave a macro partway through its changes, so it is not automatically safer than waiting. If Excel does not respond to input, these shortcuts may have no effect.

When the app is still completely unresponsive, use Task Manager only after allowing reasonable time and checking for activity. Select Microsoft Excel and choose End task as a last resort. This can discard changes since the last successful save. If Windows offers to wait for the program to respond, that option is appropriate when there are signs of continued activity or you are unsure whether a save is underway. Do not restart or power off the computer while Excel may still be writing a file unless the computer itself has stopped responding and there is no practical alternative.

Recover unsaved changes after a forced close

When Excel restarts after an unexpected closure, it may show a Document Recovery pane with available recovered files. Open the most recent candidate, compare it with what you remember, and save it under a new name before continuing. Recovery can restore some work, but it is not a promise that every recent edit or every workbook will be available.

On Excel for Microsoft 365 on Windows, you can also check File > Info > Manage Workbook for a version marked as recovered or an option to recover unsaved workbooks. The exact options depend on whether the file had been saved before and how recovery was configured. For a workbook stored in OneDrive or SharePoint, check its version history as well; it may offer an earlier cloud-saved version, but it will not necessarily contain edits that never synced.

To review recovery settings in Excel for Windows, open File > Options > Save and check whether AutoRecover is enabled and how often it saves recovery information. AutoRecover is meant to help after a crash; it is different from saving the workbook normally. If you are working on something important, use Ctrl+S regularly and consider saving a separate copy before a risky operation.

Why Excel may stop responding

Common causes include a workbook with many formulas or volatile calculations, very large data ranges, lengthy Power Query or other data refreshes, macros, and files stored on a slow or unreliable network location. A workbook can also become less responsive when the computer is low on available memory or when another application is using substantial system resources.

Add-ins are another possibility. If Excel repeatedly becomes unresponsive when starting or opening a particular file, test whether the problem also occurs in Safe Mode: close Excel, press Windows key+R, enter excel /safe, and press Enter. Safe Mode starts Excel with certain customizations and add-ins bypassed. If the problem disappears, an add-in or customization may be involved, but this test does not identify the exact cause. Review add-ins carefully rather than removing features at random.

A problem limited to one workbook points toward its contents, connections, or file state; a problem across many workbooks suggests a broader Excel, add-in, or computer issue. These are clues, not proof. Keep a separate copy before trying repairs or making large structural changes, especially if the workbook contains important data.

How to reduce the chance it happens again

For a workbook that repeatedly freezes, change one thing at a time and note whether responsiveness improves. That helps distinguish a workbook-specific issue from a general one.

Save a backup copy before refreshing data, running an unfamiliar macro, or changing a large workbook.
Close other demanding apps if the computer is short on resources, and allow Excel to finish one large task before starting another.
Check whether a refresh depends on a network location or online service that may be slow. Retry when the connection is stable rather than repeatedly launching the same refresh.
Review add-ins if Excel freezes across multiple files, and disable only a suspected add-in for a controlled test.
Keep Excel and Windows updated through the normal update channels available to your organization or device.
For important files, save regularly and use a trusted cloud location or a separate backup process. Cloud syncing and AutoSave help in some cases but are not substitutes for checking that the latest changes were saved.

Does the advice differ on Mac or Excel for the web?

This guidance primarily describes Microsoft Excel for Microsoft 365 on Windows. On a Mac, Excel may show a spinning wait indicator or appear frozen rather than using Windows’ Not Responding label. Give a demanding operation time, check whether the Mac is otherwise responsive, and avoid force quitting while a save may be in progress. The Windows Task Manager and Ctrl+Shift+Esc instructions do not apply to macOS. In Excel for Mac, Command+S is the usual save shortcut; Windows uses Ctrl+S.

Excel for the web runs in a browser, so a frozen tab can reflect the browser, the network, or the workbook service rather than the desktop Excel process. Allow time for a large operation, check the connection, and avoid refreshing the tab if unsaved changes may be present. A browser refresh or closing the tab can lose changes that have not synced. If possible, confirm the file’s saved status first. The desktop recovery options described above are not identical to the web experience.

Frequently Asked Questions

Will I lose my work if I close Excel when it says Not Responding?
Possibly. Changes since the last successful save may be lost, and recovery files are not guaranteed to include them. Wait if Excel may still be saving, and check the Document Recovery pane or cloud version history after reopening.

Is Excel frozen if Task Manager shows no CPU use?
Not necessarily. Excel may be waiting for a file, network response, or another process, and one reading does not reveal the full state. Check activity more than once and consider what operation was running.

Can I press Esc when Excel is not responding?
You can try once if the workbook appears to be calculating and Excel accepts input. If the interface is completely unresponsive, Esc may do nothing. Interrupting a macro or calculation can also leave work incomplete.

How do I get an unsaved Excel file back?
Reopen Excel and inspect the Document Recovery pane. On Windows, also check File > Info > Manage Workbook for recovery options. Availability depends on the file and recovery settings, so recovered work should be checked and saved as a new copy.

Should I wait if Excel has been stuck for an hour?
Reassess rather than waiting indefinitely. Check Task Manager, the computer’s responsiveness, and whether a large calculation or refresh is still plausibly running. If there is no activity or progress and the task is not expected to take that long, ending Excel may be necessary, with the risk of losing unsaved changes.

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.