If Excel is not responding and your work is unsaved, wait briefly and avoid repeatedly clicking; the app may still be calculating or saving. If it remains frozen, recovery may be possible with AutoRecover or Recover Unsaved Workbooks, but neither can guarantee that every recent change will return.
On Windows, give Excel time first, then reopen it only if necessary and check the recovery options before starting over. If the workbook is important, do not end Excel from Task Manager until you have decided that waiting is no longer useful: forcing it to close can discard changes that exist only in memory.
What to do before closing Excel
A Not Responding message means Windows is not receiving a timely response from Excel. It does not, by itself, prove that the program has stopped working. A large calculation, a slow network file, an external-data refresh, or a workbook with many formulas may temporarily occupy Excel. While it is busy, the window can look frozen even though work is continuing.
- Stop clicking in the workbook and wait. Give a demanding calculation or data refresh several minutes if the file is large or the computer is under load.
- Look for signs of activity, such as a changing status message or continued CPU or disk activity for Excel in Task Manager. Activity is not proof that the workbook will recover, but it is a reason to wait rather than immediately end the process.
- If Excel becomes responsive, press Ctrl+S to save, then use File > Save As to create a separate copy if you want to preserve the original too. On a Mac, use Command+S.
- If the window is still unresponsive after a reasonable wait, close Excel only as a last resort. In Windows, press Ctrl+Shift+Esc, select Microsoft Excel in Task Manager, and choose End task. This can lose unsaved changes that have not been captured by recovery.
Do not repeatedly press keys or click buttons while the program is stalled. Those actions may queue up and take effect all at once if Excel starts responding again. If the workbook is on a network or external drive, avoid disconnecting that drive while Excel may still be reading or writing the file.
Why Excel can appear frozen
Some freezes are temporary workloads; others come from a problem that needs troubleshooting. Recalculation is a common cause. For example, editing one input cell in a workbook with many dependent formulas can prompt Excel to update a large set of results. Large pivot tables, extensive conditional formatting, add-ins, and linked workbooks can also slow a session.
Other possible causes include an unavailable printer or network location, a data connection that is waiting for a response, low memory, an add-in conflict, or a damaged workbook. Excel may also stop responding while opening or saving a large file. The message alone does not identify which cause applies, so avoid assuming that a particular setting or file is responsible.
If the workbook starts responding again, note what was happening just before the freeze. Was Excel refreshing a query, calculating formulas, opening a file from a shared drive, or running an add-in? That detail can help you prevent a repeat. If the same workbook freezes every time, preserve a copy before trying repairs or changing its contents.
Recover changes after Excel closes unexpectedly
After Excel crashes or is closed, start Excel again and look for the Document Recovery pane. If it appears, review the recovered entries and their dates or times. Open the most recent plausible version, check the actual cells and sheets, and save it immediately under a new name. A recovered file may be older than the last visible edit, so verify rather than assuming it is complete.
If the pane does not appear, check for an unsaved recovery copy in Excel for Microsoft 365 on Windows:
- Open Excel and choose File > Info.
- Choose Manage Workbook, then Recover Unsaved Workbooks.
- Look for a file with a recent date or time. Open a likely candidate and inspect it before saving.
Depending on the Excel build and screen size, the Manage Workbook control may be presented as a button or menu. The recovery list may be empty, and a file may not contain the latest edits. AutoRecover depends on its settings and on Excel successfully creating a recovery copy; it is not a live duplicate of everything on screen.
Once you find a useful version, use File > Save As and choose a clear new filename and a location you can find. Keeping the recovered version separate avoids accidentally replacing a good original before you have checked both.
Find and adjust AutoRecover settings
AutoRecover periodically stores recovery information while you work. It is meant to help after an unexpected shutdown, not to replace saving the workbook. On Windows, open File > Options > Save to review whether AutoRecover is enabled and see the interval and the AutoRecover file location. The interval shown there is the one configured for that installation; it may have been changed from its default.
A shorter interval can mean a more recent recovery point if Excel closes unexpectedly, although recovery is never assured. Very frequent checkpoints can add background activity, especially with large files. Choose an interval that suits the importance and size of your work, and save manually before major changes or long operations. Do not delete recovery files while you are still trying to recover a session.
On a Mac, AutoRecover controls are in Excel settings or preferences, commonly under Excel > Settings > Save; labels can differ between releases. After a crash, reopen Excel and check for a recovery document. Mac and Windows recovery folders differ, so do not assume a Windows file path applies to a Mac.
AutoSave is different from AutoRecover
AutoSave in Microsoft 365 is designed to save changes continuously for supported files stored on OneDrive or SharePoint. In Excel, the AutoSave switch is available for eligible cloud files. A workbook saved only on the computer, or in a location that does not support this feature, may not have AutoSave available. If you can still interact with Excel, check the switch and the file location rather than assuming that all open workbooks are being saved automatically.
AutoRecover and AutoSave are not interchangeable. AutoRecover keeps periodic recovery information for an unexpected shutdown; AutoSave writes supported cloud-file changes to the saved document. Even with AutoSave, a sync delay, connection problem, or conflict can complicate recovery. If you see a useful recovered or previous version, save a separate copy and confirm that it contains the changes you need.
For a cloud workbook, version history may provide another route. In Excel, look under File > Info for Version History, or open the file through OneDrive or SharePoint and use its version-history controls. Available options depend on where the file is stored and your organization’s settings. Open an earlier version carefully and save a copy if you need to preserve the current one.
If Excel will not reopen the workbook
First distinguish a damaged saved workbook from edits that were never saved. Repair tools work on a file that exists; they cannot reconstruct every unsaved change that was only in the frozen session. Make a copy of the saved workbook before attempting repair, particularly if it is important or shared.
To try Excel’s repair option in Windows, choose File > Open > Browse, select the workbook, then use the arrow beside the Open button and choose Open and Repair. Follow the prompts and inspect any repaired result. If the file is stored in OneDrive or SharePoint, version history may be preferable to experimenting on the only copy. If the workbook opens but repeatedly freezes, test a copy with unnecessary add-ins disabled or ask your IT support team to investigate the file, connection, or installation.
After recovery: verify and protect the file
Do not judge recovery only by the workbook opening successfully. Check the last edited sheet, recent entries, formulas, and any data-refresh results. A formula may still be present while its displayed value is stale, and a query may not have completed. Compare the recovered timestamp with when you last remember making a change.
Save the recovered workbook under a new name, then close and reopen that copy to confirm it is readable. If others use the workbook, tell them which copy is current before replacing a shared file. For important work, keep a second copy in a different location or use an approved cloud location with version history. A single unsaved session is not a backup strategy.
Reduce the chance of losing work next time
- Save early with Ctrl+S on Windows or Command+S on Mac, and save again after meaningful changes. Consider a new filename before a risky edit.
- Check AutoRecover in File > Options > Save on Windows, and make sure the setting is enabled if you rely on it.
- Use OneDrive or SharePoint AutoSave for eligible files when that fits your work and organization’s rules; confirm that the file is actually saved in the intended cloud location.
- Before refreshing external data, running a macro, or making a large structural change, save a separate copy.
- If one workbook regularly stalls, investigate its formulas, data connections, add-ins, and file location instead of treating every freeze as a recovery problem.
These habits reduce the amount at risk, but no recovery feature can promise a complete copy after every crash. Manual saves remain useful even when AutoSave or AutoRecover is enabled.
Frequently Asked Questions
Should I wait or force quit Excel?
Wait if Excel may be calculating, saving, or refreshing data, especially if Task Manager shows activity. Force quit only when it remains unresponsive after a reasonable wait and you accept that unsaved changes may be lost.
Where is Recover Unsaved Workbooks in Excel?
In Excel for Microsoft 365 on Windows, go to File > Info > Manage Workbook > Recover Unsaved Workbooks. The option may show no files if Excel did not create a recovery copy.
Can I recover a workbook if AutoRecover was off?
You can still check Document Recovery, Recover Unsaved Workbooks, and cloud version history if relevant, but the odds are lower. If no recovery or saved copy exists, Excel may not be able to restore edits that were never saved.
Does AutoSave save a workbook stored on my computer?
Usually, Microsoft 365 AutoSave applies to supported files stored on OneDrive or SharePoint, not an ordinary local-only file. Save local workbooks manually and check the AutoSave switch and file location.
Will reopening Excel restore every change?
No. Excel may offer a recovery version, but it can be older than the last edits or unavailable. Open likely copies, compare their contents, and save the best candidate under a new name.
Related
- Excel Group Rows Count: How to Count Rows in Groups
- Excel Group Rows Into a Dropdown: What Actually Works
- Excel Group Duplicate Rows Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Keyboard Shortcuts to Select Cells and RangesIn Excel for Microsoft 365 on Windows, use Ctrl+A to select the current data region, then press it…
- Excel Middle Value Extraction: Find the MedianTo get the middle value of a numeric list in Excel, use =MEDIAN(A2:A7) when the values are in…
- Excel Data Validation: Make Lists DynamicYes. In Excel for Microsoft 365, a data-validation drop-down can update when its source list grows, changes, or…
- Where Is the Remove Formatting Button in Microsoft Word?In Microsoft Word for Microsoft 365 on Windows, find the remove-formatting button on the Home tab, in the…
- How to Create a Digital Signature in OutlookTo create the signature most people mean—a name, contact details, or a sign-off that appears at the bottom…
- Changing Indent in Word: A Practical GuideTo change an indent in Microsoft Word for Microsoft 365 on Windows, select the paragraph or paragraphs, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.