Excel Not Responding? How to Protect and Recover Work

If Excel says “Not Responding,” stop clicking and give it time to finish; it may be busy calculating, opening a large file, or waiting on an add-in. If it becomes responsive, save a separate copy immediately; if it does not, use AutoRecover or a cloud version history after restarting before assuming your work is gone.

First, give Excel a chance to recover

“Not Responding” means Windows is not receiving a timely response from Excel’s window. It does not by itself mean the workbook is damaged or that every change has disappeared. Excel may be processing a large calculation, refreshing external data, loading a workbook with many formulas, or responding slowly to a busy computer. A brief pause can clear on its own; repeatedly clicking the window or pressing keys can create extra queued actions or open unwanted dialogs.

Wait while watching for signs of activity: a changing status message, a progress indicator, disk activity, or the window becoming responsive again. The time required depends on the workbook and computer, so there is no universal safe number of minutes. If Excel is working on a large refresh or calculation, interrupting it can leave the task incomplete. Avoid restarting Windows or shutting down the computer while you are still giving Excel a reasonable chance to finish.

Do not click the workbook repeatedly or launch another copy of the same file to try to force a save.
If Excel returns, press Ctrl+S on Windows (Command+S on Mac) and wait for the save to complete.
For especially valuable work, use File > Save As to create a second copy under a new name or in a different safe location.
If the file is stored in OneDrive or SharePoint, check whether AutoSave is on, but do not assume a recent edit has synced until the app is responsive and the status indicates it is saved.

Try a safe interruption before closing

If a formula calculation appears stuck, you can try interrupting the calculation rather than immediately ending Excel. On Windows, Ctrl+Break may stop a calculation; on some keyboards, Break requires a function-key combination. Excel may show an option to end the calculation. This is not a general fix for every freeze, and it may not work while Excel is handling another operation or a dialog. Avoid pressing it repeatedly.

If Excel is responsive enough to accept commands, try Esc once to cancel an active edit or dismiss an operation that can be canceled. Then save. Esc is not a recovery command and cannot restore unsaved changes after Excel has been closed. On a Mac, Command+Period can interrupt some ongoing operations, but behavior depends on what Excel is doing. If the workbook is simply calculating, let it finish when possible rather than interrupting work that may take time to recompute.

When Excel is fully frozen, the operating system may eventually offer to wait or close the program. Choose to wait if you have not yet allowed a reasonable period for the task to complete. Closing is the last resort because changes since the last successful save may be lost, even if AutoRecover later retrieves some of them.

If Excel becomes responsive, save a recoverable copy

As soon as you can use the ribbon or keyboard, save before investigating the cause. Press Ctrl+S (Command+S on Mac). If you see a syncing message or a save error, use File > Save As and choose a local folder you can access, such as Documents, with a new filename. This can preserve a snapshot without overwriting the original. If Excel offers a file format choice, keep the workbook in its existing format unless you have a reason to change it; saving as CSV, for example, removes workbook features such as multiple sheets, formatting, and formulas.

Wait for the save or upload indicator to finish. In Microsoft 365, AutoSave is generally available for files saved to OneDrive or SharePoint, but it depends on the file and account setup. AutoSave is not the same as AutoRecover: AutoSave writes changes to a supported cloud file as you work, whereas AutoRecover periodically saves recovery information to help restore work after a failure. A cloud file’s version history can also help if a saved change needs to be rolled back, but it cannot guarantee that an unsaved, still-frozen edit reached the cloud.

What to do if you must force Excel to close

If Excel remains frozen and waiting is no longer practical, closing it may be necessary. Understand the tradeoff: anything not saved or captured by recovery may be lost. On Windows, open Task Manager with Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. On Mac, press Option+Command+Esc, select Microsoft Excel, and choose Force Quit. These commands terminate the application; they do not save the workbook.

After closing, reopen Excel and look for the Document Recovery pane. If recovered files appear, open the most recent candidate, compare its contents with what you remember, and save it using a new filename before replacing the original. If Excel opens without showing the pane, recovery may not have been available or may not have found changes. Check the file’s normal location and cloud version history before concluding that no copy exists. Do not delete temporary or recovery files while investigating.

For an unsaved workbook in Excel for Microsoft 365 on Windows, try File > Info > Manage Workbook > Recover Unsaved Workbooks, if that option is available. Open a likely candidate and save it immediately. The exact recovery choices can vary with the file’s state and Excel build, and a recovery entry is not proof that every recent edit is present. On Mac or Excel for the web, the available recovery route differs; check the app’s recovery prompt or the cloud file’s version history rather than expecting the same Windows menu.

How AutoRecover and AutoSave differ

AutoRecover is a safety net, not a substitute for saving. In Excel for Microsoft 365 on Windows, the AutoRecover settings are under File > Options > Save. The interval controls how often Excel stores recovery information, and the option to keep the last AutoRecovered version when closing without saving can affect what is retained. A shorter interval can reduce the amount of work at risk in some crashes, but it does not guarantee recovery of the latest keystroke or every workbook state. The setting may also be controlled by an organization.

AutoSave is designed for supported files stored in OneDrive or SharePoint. When it is on, changes are saved to the cloud as you work, making it useful for ongoing protection and collaboration. A network interruption, sync delay, unsupported file condition, or disabled toggle can affect saving. Look at the AutoSave switch and save-status messages in Excel rather than relying on memory. For files stored only on a local drive, ordinary Ctrl+S saves and AutoRecover remain important.

Version history is another layer, especially for cloud-stored files. It can let you inspect or restore an earlier saved version if a workbook was overwritten or an unwanted edit synced. It is different from AutoRecover: version history concerns saved file versions, while AutoRecover aims to help after an unexpected application closure. Before restoring an older version, consider saving the current one under another name so you can compare them.

Find the reason for repeated freezes

One freeze may be temporary. Repeated freezes often point to a workbook, add-in, calculation, connection, or system resource problem. If Excel works normally with other files but freezes with one particular workbook, the file’s formulas, formatting, external links, pivot tables, data connections, or size may be contributing. If several workbooks freeze, investigate add-ins, Office updates, available memory, and other programs competing for resources.

After recovering and saving the file, test Excel in Safe Mode on Windows. Close Excel, press Windows key+R, type excel /safe, and press Enter. If the problem disappears in Safe Mode, an add-in or customized setting may be involved; this test does not identify the exact cause. To inspect add-ins in normal Excel, use File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list, select Go, and disable an add-in only if you can identify it and are prepared to test. Restart Excel normally and re-enable items one at a time to isolate a cause. Menu options can differ for other add-in types.

Large calculation workloads can also look like a freeze. Volatile formulas, formulas applied to entire columns, extensive conditional formatting, and repeated lookups across large ranges may increase recalculation time. External data refreshes and links to unavailable files can pause progress. After making a backup, try opening a copy of the workbook and investigate recent changes rather than deleting formulas or links from the only version. If the workbook is shared or business-critical, ask its owner or IT support before changing connections.

Reduce the chance of losing work next time

Use several protections together rather than depending on one recovery feature. Save early, save regularly, and keep an independent copy of important files. For cloud workbooks, confirm AutoSave is active and allow synchronization to complete before closing the laptop or disconnecting. For a local workbook, establish a saving habit that fits the task; a quick Ctrl+S after a major edit is often more useful than relying on an automatic recovery interval alone.

Before a risky import, formula rewrite, or workbook cleanup, use File > Save As to create a dated working copy.
Keep the file in a location included in your organization’s approved backup or cloud-sync process, and confirm that backups actually run.
Use clear filenames or version history so you can distinguish the last known-good file from an experimental copy.
Install Microsoft 365 updates through your organization’s normal process, particularly if freezes started after a change.
Close unused applications and avoid running several large spreadsheet calculations at once on a resource-limited computer.

Do not treat a “saved” indicator as a backup plan. If a file is overwritten, damaged, or synced incorrectly, a separate backup or prior version can matter. Conversely, making many duplicate copies without clear names can lead to editing the wrong workbook. A simple naming scheme such as a project name plus date can make recovery choices easier.

Common mistakes that make recovery harder

The most tempting mistake is force-closing Excel as soon as the title bar changes. That can discard changes that would have been saved if the calculation or refresh had finished. The opposite mistake is waiting indefinitely when Excel is clearly unable to proceed. There is no universal timeout; use the work in progress, signs of activity, and the importance of the unsaved changes to decide when to wait and when to close.

Another misconception is that AutoRecover stores every keystroke. It does not promise that. Recovery points are periodic, and a failed save, damaged file, or unsupported situation can limit what is available. Similarly, AutoSave does not mean that every change is immediately safe under every network condition. Check the actual save state, then preserve a separate copy when the work matters.

Avoid repeatedly reopening the same problematic file while Excel is still closing or recovering. Wait for the application to exit, reopen Excel once, and inspect its recovery choices. Also avoid saving a recovered workbook over the only original before checking it. A different filename preserves both candidates while you determine which contains the latest usable information.

Frequently Asked Questions

Should I wait or end task when Excel is not responding?
Wait first if Excel may be calculating, refreshing data, or saving, and look for signs of progress. If it remains unresponsive and you cannot continue waiting, ending the task is an option, but unsaved changes may be lost. Reopen Excel afterward and inspect recovery options.

Will AutoRecover bring back my latest changes?
Possibly, but it is not guaranteed to include the latest edits. AutoRecover saves recovery information periodically, so changes made since the last recovery point may be missing. Open the recovered file, check its contents, and save it under a new name.

Where are unsaved Excel files recovered in Windows?
In Excel for Microsoft 365, check the Document Recovery pane after restarting. You can also try File > Info > Manage Workbook > Recover Unsaved Workbooks when that command is available. Recovery options and results depend on the circumstances and Excel configuration.

Does AutoSave work if my workbook is on my computer?
AutoSave is generally intended for supported files stored in OneDrive or SharePoint, not every local file. For a workbook stored on your computer, use Ctrl+S regularly and check File > Options > Save for AutoRecover settings. A cloud-sync status should be confirmed rather than assumed.

Can I recover a workbook after clicking Don’t Save?
Sometimes, if Excel retained an AutoRecovered or unsaved-workbook copy, but selecting Don’t Save can remove the normal saved changes. Reopen Excel and check its recovery pane and the unsaved-workbook option. If the file was in OneDrive or SharePoint, review version history for saved versions; neither route guarantees recovery of every edit.

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.