Excel Not Responding? Recover an Unsaved File

How-to basics · Updated November 19, 2026

If Excel is not responding and your work has not been saved, do not force-close it right away. Give it time, try saving if it becomes responsive, and, if you eventually have to close it, reopen Excel and check Document Recovery and Recover Unsaved Workbooks; recovery is possible but not guaranteed.

What to do before closing Excel

A frozen window does not always mean Excel has stopped working. It may be calculating formulas, refreshing data, opening a large workbook, or waiting for another process. On Windows, the title bar may show Not Responding while the program is busy. Wait several minutes before taking action, especially if the workbook is large or contains complex calculations. Avoid repeatedly clicking the window or pressing keys: queued actions may run all at once if Excel starts responding again.

If the window begins responding, press Ctrl+S once and wait. For a workbook that has never been saved, Excel may open the Save As dialog instead. Choose a folder you can find, give the file a clear name, and save it. If Excel remains frozen, repeatedly pressing Ctrl+S cannot make it save; the command may simply be waiting in a queue. If you see a calculation or data-refresh message, allow it to finish rather than interrupting it.

Before ending the task, check whether the computer itself is still working and whether other applications respond. If you must close Excel, use Task Manager only as a last resort: press Ctrl+Shift+Esc, select Microsoft Excel, and choose End task. This discards unsaved work currently held in memory. Do not restart or power off the computer first unless the whole system is unresponsive, because that also closes the program without giving it a chance to finish.

Why Excel can become unresponsive

Excel can appear frozen during work that takes substantial time or memory. Common causes include recalculating many formulas, opening a large file, refreshing a query or external connection, running a macro, or processing a workbook with extensive formatting. Add-ins, low available memory, a network location that is slow or unavailable, and a damaged workbook can also contribute. A long delay alone does not prove that the file is corrupted.

Consider what Excel was doing when the problem started. If you had just opened a workbook, wait for loading or recalculation. If you clicked Refresh All, an external data source may be the bottleneck. If the problem happens repeatedly with one workbook but not others, the workbook itself, its links, or its contents may be involved. These clues can help with later troubleshooting, but the immediate priority is to avoid losing the open session before recovery options are checked.

AutoSave and AutoRecover are different

AutoSave is the switch near the top-left of Excel for Microsoft 365. When it is available and turned on for a workbook stored on OneDrive or SharePoint, Excel saves changes to that cloud file as you work. It is designed to keep the shared or cloud-stored document current, but it is not a promise that every keystroke has reached the service at the instant Excel freezes. Network interruptions, sign-in problems, or a disabled switch can affect saving.

AutoRecover is a separate desktop feature. It periodically keeps recovery information so Excel may restore work after an unexpected shutdown. On Windows, its settings are under File > Options > Save. There you can check whether Save AutoRecover information every … minutes is enabled, adjust the interval, and check Keep the last AutoRecovered version if I close without saving. The AutoRecover file location is also shown on this page. The interval matters: changes made since the most recent recovery snapshot may not be available.

Neither feature should be treated as a substitute for deliberately saving a file. AutoSave usually applies to supported cloud files, while AutoRecover is a fallback after a problem. A new workbook that has never been named and saved is not the same as an existing workbook with unsaved edits: the existing file still has its last saved copy, but a new workbook may depend entirely on a recovery copy. The exact recovery outcome depends on what was enabled and what Excel managed to write before it stopped.

Check Document Recovery after restarting

If you had to close Excel, open it again and look for the Document Recovery pane. After an unexpected shutdown, Excel may list one or more recovered versions with a time or date. Open the version that seems most recent and inspect it before relying on it. If it contains the missing changes, use Save As to save a separate copy with a clear name. Saving a new copy first helps preserve the recovered version while you confirm that its contents are complete.

Do not assume that the first item in the pane is automatically the right one. If several versions appear, compare their timestamps and check important sheets, recent entries, and formulas. A recovered file can contain only the work captured by the last recovery snapshot, not every edit made before the freeze. If Excel offers a choice to view or save a recovered file, save the version you need before dismissing the pane.

If the pane does not appear, look for unsaved workbooks through File > Info > Manage Workbook > Recover Unsaved Workbooks. In some Excel layouts, you can also reach the recovery link from File > Open > Recent. Open any candidate and immediately save it under a new name. These locations are worth checking even when the original workbook was never saved, but an empty list means Excel has no available recovery file there.

Look for a cloud or previously saved copy

If the workbook was already saved to OneDrive or SharePoint, check the file in its normal location and confirm that you are signed in to the correct account. Excel may have saved some changes before it stopped, even if the last few edits did not sync. For a saved cloud workbook, File > Info > Version History can show earlier versions. You can open a version to inspect it and save a copy rather than replacing the current file immediately.

Version History is not the same as recovering a brand-new, never-saved workbook. It helps when a file already exists and stored versions are available. If you use a local file or a workplace network folder, check the folder for the original file and any copies you intentionally made; do not assume that a temporary-looking file is a complete backup. If Excel offers a recovered copy, preserve it separately before comparing it with the last saved version.

If no recovery file appears

First confirm that you are checking the same Windows account and Excel installation used when the workbook was open. Then revisit File > Options > Save and note the AutoRecover file location. You can inspect that location in File Explorer, but do not rename, move, or delete unfamiliar files while Excel is open. A recovery file may be temporary, incomplete, or unreadable, and changing it can make it harder to assess. If a candidate opens, save a copy to a normal folder immediately.

If Excel has no Document Recovery entry, no unsaved workbook is listed, and no usable file exists in the AutoRecover location, the missing edits may not be recoverable. AutoRecover is periodic and can fail to create a usable copy; it does not record every change continuously. Avoid downloading random recovery utilities or deleting files in an attempt to force recovery. For a work or school device, an IT administrator may know whether a managed backup or cloud version history is available.

A common misconception is that closing a frozen workbook always triggers a complete recovery copy. It does not. Recovery depends on saved data that existed before the failure, the AutoRecover or AutoSave state, and whether Excel can read the resulting file. If the file was never saved and no recovery copy was created, there may be no complete copy to restore.

Reduce the risk of losing work next time

  • Save a new workbook early with Ctrl+S and choose a recognizable location and filename. Save again after substantial changes.
  • For a supported OneDrive or SharePoint workbook, check that AutoSave is on and that Excel is signed in. Allow time for changes to sync before closing or switching devices.
  • Review File > Options > Save and make sure AutoRecover is enabled. A shorter interval can reduce the amount of work between recovery snapshots, though it cannot eliminate the risk of loss.
  • Keep a separate backup for important work. Version History or another backup can help with an existing saved file, but a backup is useful only if it is available and current enough for your needs.
  • If Excel often hangs, investigate whether the issue follows one workbook, a particular add-in, or a specific task such as refreshing data. Save a copy before troubleshooting a valuable workbook.

When you are working in Excel for the web, changes are saved to the cloud workbook rather than to a local desktop recovery file. Confirm that the correct workbook is open and that connectivity is available. On a Mac, recovery and save controls are arranged differently from Windows, but the same general caution applies: wait if the app may still be processing, then reopen Excel and inspect any recovery prompt before continuing.

Frequently Asked Questions

Will Excel recover an unsaved workbook automatically? Sometimes. Excel may show a Document Recovery pane after an unexpected shutdown, or the workbook may be available through Recover Unsaved Workbooks. Whether a copy exists depends on recovery settings and whether Excel successfully created one, so automatic recovery is not guaranteed.

How long should I wait before force-closing Excel? There is no reliable fixed wait time. Give Excel several minutes, and longer if it was opening a large workbook, calculating, or refreshing data. If the computer is still responsive, waiting is safer than immediately ending the task. If Excel remains stuck and no save is possible, closing it may be the only practical option.

Can I recover a file I never saved? Possibly, by checking Document Recovery and File > Info > Manage Workbook > Recover Unsaved Workbooks. If neither location contains a usable copy, Excel may not have stored the workbook. Recovering unsaved work is less certain than reopening a file that was saved previously.

Does AutoSave mean I will not lose any changes? No. AutoSave helps save supported cloud files as you work, but it depends on the file being stored in a supported location and on the save or sync process completing. It is different from AutoRecover, and a freeze or connection problem can leave recent edits unsaved.

What should I do if Excel opens a recovered version? Open it, check the timestamp and contents, then use Save As to create a separate file. Review important recent changes rather than assuming the recovery copy includes everything. Keep the original saved file until you have confirmed which version contains the work you need.

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.