Excel Not Responding? Recover Files and Find Temp Data

If Excel is not responding, first give it a minute and avoid repeatedly clicking or ending the task; it may be calculating, saving, or waiting on an add-in. If it closes or you must stop it, reopen Excel and check the Document Recovery pane, then use File > Open > Recent > Recover Unsaved Workbooks; temporary files sometimes help, but they are not guaranteed backups.

What to do before closing a frozen workbook

A frozen window does not always mean Excel has lost the workbook. Large calculations, external data refreshes, macros, or a slow network location can make the program appear unresponsive while it is still working. Look for signs of activity, such as changing CPU or disk use in Task Manager, and allow time for the operation to finish. A workbook with many formulas or links may take several minutes to recalculate after a change.

Try these steps in order:

Wait briefly, especially if you just opened a large workbook, refreshed data, or changed many cells.
Press Esc once to try to interrupt a calculation or action. It may not work if Excel is blocked by another operation.
If the workbook becomes responsive, use File > Save As to save a separate copy under a new name. This protects the recovered state while leaving the original intact.
If Windows offers a choice to wait or close the program, choose to wait first when you can. End the task only when Excel remains stuck and waiting is not practical.

Ending Excel through Task Manager can discard changes that exist only in memory. Before doing so, note where the workbook was saved and whether it was stored locally, on a network drive, or in OneDrive or SharePoint. That information helps you choose the right recovery route after restarting.

What Excel temporary files do

Excel uses temporary working files during tasks such as editing and saving. A temporary file can hold intermediate data while Excel writes a workbook, and some temporary files disappear after the operation completes. If Excel or Windows stops unexpectedly, remnants may remain. Their presence does not prove that they contain a complete, current copy of your workbook.

Several kinds of files are often confused:

AutoRecover data is created according to Excel’s AutoRecover settings. It is intended to help restore work after an unexpected shutdown, but it may reflect an earlier point than your last edit.
Office owner or lock files can appear next to a workbook while it is open. Names beginning with ~$ are commonly associated with a workbook’s open state; they are not normally a second copy of the workbook’s contents.
General temporary files may have a .tmp extension or an unfamiliar name. Windows and many applications use the temporary folder, so a file there is not necessarily an Excel recovery file.
Cloud version history is separate from local temporary files. OneDrive and SharePoint can retain earlier versions when version history is available and enabled.

Do not judge a file solely by its name or extension. A file called ~$Budget.xlsx is generally a lock or owner file, while an unrelated temporary file might belong to another application. Avoid changing extensions or opening random files in Excel: a temporary file may be incomplete, and renaming it does not turn it into a valid workbook.

Recover an unsaved workbook in Excel

After Excel restarts, look first for the Document Recovery pane, usually displayed at the left of the workbook window. If several versions appear, check their timestamps and open the most recent plausible one. Save a recovered copy immediately with File > Save As. Do not assume that the newest timestamp necessarily includes every last change; review important sheets and formulas before replacing an original file.

If the pane is absent, try the built-in unsaved-workbook location:

In Excel for Microsoft 365 on Windows, select File > Open > Recent.
Choose Recover Unsaved Workbooks, generally shown near the bottom of the page.
Open a candidate and, if it contains the needed work, save it as a normal workbook using File > Save As.

Some builds also expose recovery information under File > Info, including a Manage Workbook area. The exact label or availability can vary with the Excel build and the kind of file, so the Recent page is a useful alternative. If the workbook had previously been saved, open its normal saved location too; the best recovery may be the original file, a recovered version, or a cloud version rather than a loose temporary file.

Check AutoRecover and AutoSave settings

To see whether AutoRecover is configured, open File > Options > Save. The Save AutoRecover information every setting controls how often Excel creates recovery information, and the AutoRecover file location shows where Excel stores it. A shorter interval can reduce the amount of work at risk, though recovery still is not a promise that every edit will be preserved. Do not change or clear that location while trying to recover a missing workbook.

AutoRecover and AutoSave are different. AutoRecover is a recovery mechanism controlled in Excel’s Save options. AutoSave is designed for supported files stored in OneDrive or SharePoint and can save changes continuously; it is not a general replacement for AutoRecover on a workbook saved only to a local drive. The AutoSave switch may be unavailable for a local file or a file type that does not support it. For cloud files, check the file’s version history as well as Excel’s recovery options.

On a Mac, menu names and recovery locations differ from Windows, and Windows paths such as the %temp% folder do not apply. Use Excel for Mac’s recovery prompts and its AutoRecovery preferences rather than following Windows folder instructions. The procedures here describe Excel for Microsoft 365 on Windows.

Look for temporary files carefully

If the normal recovery options do not find the workbook, you can inspect the Windows temporary folder, but treat it as a last-resort search rather than a standard recovery method. Press Windows key+R, type %temp%, and press Enter. Sort by Date modified and look for files created around the time Excel stopped responding. This folder contains data from many programs, and Windows may remove temporary files automatically.

Before doing anything with a candidate, copy it to another folder. Check whether its size is plausible and whether Excel can open the copy through File > Open > Browse. If Excel reports that the format or extension is invalid, do not repeatedly rename the file or overwrite the original. An incomplete save may not be repairable, and a leftover file may contain only intermediate data. You can also search the workbook’s original folder for a recent file with a similar name, but distinguish it from any ~$ owner file.

Avoid running a disk-cleanup tool or deleting files from the temporary folder until recovery attempts are finished. Removing a lock file does not restore workbook content, and deleting a genuine recovery artifact can make recovery harder. Once you have saved and checked a recovered workbook, ordinary cleanup is less risky.

Why Excel may stop responding

Temporary files can be involved in a save, but they are not automatically the cause of a hang. Common triggers include a workbook with heavy formulas or links, an add-in that is stuck, a macro, a damaged workbook, low available memory, a slow network or cloud connection, or an Office problem. A nearly full drive can also interfere with saving because Excel and Windows need working space.

If the same workbook repeatedly freezes, test whether the problem is limited to that file. Open a blank workbook, then try a copy of the affected file from a local folder. If Excel starts normally but freezes with a particular workbook, the file’s contents, links, or connections may be involved. If Excel freezes with different workbooks, an add-in or installation issue becomes more plausible.

For a basic add-in check, close Excel and start it in Safe Mode by pressing Windows key+R, entering excel /safe, and pressing Enter. If Excel behaves better there, open File > Options > Add-ins. In the Manage box, select COM Add-ins, choose Go, and temporarily clear selected add-ins. Restart Excel normally to see whether the behavior changes. Re-enable add-ins one at a time to identify a possible cause; do not disable an add-in permanently if your workplace depends on it without checking with IT.

When recovery fails and how to reduce future loss

If no usable recovery copy exists, check the Recycle Bin, the workbook’s original folder, and any backup or cloud version history available to you. For a file on OneDrive or SharePoint, open its version history from the service or the file’s context menu and inspect earlier versions before restoring one. For a work or school device, an administrator may have backups unavailable through Excel itself. If a file opens with an error, make a copy first and use Excel’s Open dialog options cautiously; repair attempts can alter a file, so preserve the original.

To reduce the chance of losing work:

Save important workbooks to a known location and use clear filenames or dated copies before a major change.
Review File > Options > Save and confirm that AutoRecover information is being saved at a useful interval.
Use OneDrive or SharePoint for supported files when cloud saving and version history suit your workflow, while still checking that the status indicates the file has saved.
Keep enough free disk space and update Microsoft 365 through your organization’s normal update process.
For critical work, maintain a separate backup. AutoRecover is a convenience, not a substitute for a backup plan.

Clearing temporary files is therefore not a general fix for Excel not responding. It may free disk space, but it can also remove material that could be useful during recovery, and it will not address a faulty add-in, slow calculation, or damaged workbook. Recover first, then troubleshoot the underlying reason for the freeze.

Frequently Asked Questions

Can I recover an Excel file from the Temp folder?
Sometimes, but there is no guarantee that a file in %temp% is a complete workbook. Try Document Recovery and Recover Unsaved Workbooks first, then inspect a copied candidate rather than editing or renaming the only original.

Does a file starting with ~$ contain my unsaved changes?
Usually not. A ~$ file is commonly an owner or lock file associated with an open workbook, not a recoverable copy of its sheets. Look for AutoRecover data, a saved workbook, or cloud version history instead.

Will Excel AutoRecover every change?
No. AutoRecover saves recovery information at an interval set in File > Options > Save, and the latest edits may fall between saves. It helps reduce loss but does not guarantee recovery of every change.

Should I end Excel in Task Manager if it says Not Responding?
Only after allowing time for a possible calculation, refresh, or save to finish. Ending the task can discard unsaved changes held in memory. If you must close it, reopen Excel promptly and check the recovery pane and unsaved-workbook list.

Does deleting temporary files make Excel work again?
Usually not by itself. It may free disk space, but it does not fix most causes of a freeze and could remove a useful recovery artifact. Recover important work first, then investigate add-ins, workbook complexity, storage, or Office issues.

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.