How to Recover an Excel File Not Saved in Office 365

Losing an Excel workbook after a crash, accidental closure, or failed save can leave you searching for a file that seems to have disappeared. The recovery path depends on what happened: a workbook that was never saved, a saved workbook with missing changes, or a file stored online through Microsoft 365. This guide shows how to recover autosaved Excel files by using built-in recovery tools, AutoRecover locations, and cloud version history when available.

To recover an unsaved Excel file in Office 365, open Excel and go to File > Info > Manage Workbook > Recover Unsaved Workbooks, then select the available workbook copy and save it as a new file. If the workbook is not listed, check the AutoRecover folder, temporary files, OneDrive or SharePoint Version History, and other recovery locations based on how the file was stored.

Recover an unsaved Excel workbook in Office 365

When an Excel workbook has never been saved and Excel closes unexpectedly, the first place to check is Excel’s built-in recovery area. This method works only when Excel created a temporary recovery copy before the application closed.

Use the following path to look for a recoverable workbook:

1. Open Microsoft Excel.
2. Select File from the top menu.
3. Choose Info.
4. Open Manage Workbook.
5. Select Recover Unsaved Workbooks.
6. Choose the workbook from the list of available files.
7. Open it and immediately use Save As to create a permanent .xlsx file.

The recovered workbook may not have every recent edit. AutoRecover saves temporary states rather than creating a guaranteed duplicate of every action, so the restored version depends on when Excel last captured recovery information.

A simple decision rule helps avoid wasting time:

Recovery path by situation

If the workbook appears, save it immediately under a new name. Continuing to edit a recovered temporary copy without saving can create another loss situation.

Restore work after crashes with Excel recovery tools

Excel has multiple recovery features because different failures create different types of lost data. A crash during editing is not the same problem as deleting a file or closing a workbook without saving.

Using the Document Recovery pane after closure

After Excel stops unexpectedly, reopening the application may trigger the Document Recovery pane. This pane displays available recovered versions that Excel created before the interruption.

Check each listed workbook version carefully. The newest-looking file is not always the best choice because a recovery copy may represent a point before the last edits were entered.

To restore work from the Document Recovery pane:

1. Restart Excel after the crash or forced closure.
2. Look for the Document Recovery pane on the left side of the window.
3. Open the available recovered version.
4. Compare the recovered content with what you remember changing.
5. Save the recovered workbook as a new file.

If the pane does not appear, Excel may not have a usable recovery copy. Close and reopen Excel once more, then check the Recover Unsaved Workbooks option described earlier.

Managing saved workbooks with built-in recovery

A saved Excel workbook and a never-saved workbook require different recovery approaches. The Manage Workbook feature is designed for finding previous temporary versions of files that Excel had already opened and worked on.

AutoRecover and AutoSave are related but serve different purposes. AutoRecover creates temporary recovery information for situations such as crashes or unexpected closures. AutoSave continuously saves changes for supported files stored in locations such as OneDrive or SharePoint.

In practical Excel recovery work, the easy-to-miss step is identifying whether the missing content existed only in memory or whether it was already saved somewhere. A workbook that was saved previously may have more recovery paths than a brand-new workbook that was closed before its first save.

Troubleshoot missing Excel recovery files

Finding nothing in Excel’s recovery list does not always mean every option is gone. It means the next checks should focus on where Excel stores temporary information and where the original workbook may have existed.

When Recover Unsaved Workbooks shows nothing

An empty Recover Unsaved Workbooks list usually means Excel did not keep a usable temporary copy in the location it checks. Common reasons include Excel closing before AutoRecover captured the workbook, temporary files being removed, or the workbook never reaching a recovery state.

Use this troubleshooting sequence:

1. Confirm whether the workbook was ever saved with a filename. A never-saved workbook and a saved workbook with missing edits require different checks.
2. Check the AutoRecover folder manually.
3. Search temporary folders for possible Excel recovery files.
4. Check OneDrive or SharePoint history if the file was stored online.
5. Check the Recycle Bin if the problem involved deletion rather than unsaved changes.

A useful diagnostic signal is the type of loss. If the file existed before and only recent edits disappeared, look for versions or backups. If no filename was ever created, only temporary recovery copies can help.

From an editorial review of Excel recovery workflows, the recurring failure mode is treating every missing workbook as the same problem. The recovery method should follow the event that caused the loss, not just the fact that the file is missing.

Finding AutoRecover and temporary Excel files

When the normal recovery menu does not show the workbook, check the folders where Excel may store temporary recovery data. Common locations include:

C:Users<username>AppDataLocalMicrosoftOfficeUnsavedFiles

and:

C:Users<username>AppDataRoamingMicrosoftExcel

Look for files that may have Excel-related extensions such as .asd, .tmp, or .xlsx. File names may not match the original workbook name, so checking file dates and opening possible candidates is often necessary.

For example, if Excel closed while a new workbook was open and Recover Unsaved Workbooks is empty, the next practical checks are the AutoRecover folders and temporary files. If those locations contain no recent files, Excel may not have created a recovery copy for that session.

Checking local files with File Explorer

File Explorer can help locate temporary files that are not visible through Excel’s recovery menus. This is especially useful when a workbook was stored locally on a Windows computer.

Open File Explorer and search locations connected to the missing workbook. You can also check the Windows temporary folder by entering %TEMP% in the address bar and looking for files beginning with ~ or ending in .tmp.

A safer search process is:

1. Open File Explorer and navigate to %TEMP%.
2. Sort files by date modified to find items created around the time Excel closed.
3. Check files with temporary Excel-related names or extensions.
4. Copy possible candidates to another folder before opening them.

Temporary files are not guaranteed backups. A missing file in these locations can mean Excel did not preserve enough information to reconstruct the workbook.

Choose the right recovery path for your file situation

Before trying every recovery method, identify what actually happened to the workbook. The fastest recovery option depends on whether the workbook was never saved, whether saved changes disappeared, or whether the file existed online.

Recovery methods by file situation

Use this checklist if you are unsure where the workbook was stored:

• Confirm whether the missing workbook was stored locally on your device, in OneDrive, or in SharePoint.
• Check whether AutoRecover was active and recording temporary states before the interruption.
• Verify whether a previous saved version exists before attempting unsaved workbook recovery workflows.

Recovering a workbook that was never saved

A never-saved workbook has no original file path to restore. Excel can only recover it if it created a temporary copy while the workbook was open.

The correct approach is to start with Recover Unsaved Workbooks. If that list contains a file created around the time of the loss, open it and save a new copy.

The limitation is important: if Excel closed before creating recovery information, there may be no workbook copy to restore. A blank recovery list after a never-saved session is a sign that the temporary recovery process did not capture the workbook.

Restoring unsaved changes to saved files

A previously saved workbook has a different recovery pattern. The original file may still exist, but edits made after the last save may be missing.

In this situation, check the Document Recovery pane first after restarting Excel. If the file is stored online, Version History may also show earlier saved versions.

The key question is whether the missing content was ever written to storage. A saved workbook with missing edits may have older versions available, while a brand-new unsaved workbook depends entirely on temporary recovery copies.

Selecting methods by storage location

Storage location changes the recovery options available:

• Local workbook: check Excel recovery tools, AutoRecover folders, temporary files, and Windows file locations.
• OneDrive or SharePoint workbook: check Version History before searching local temporary folders.
• Deleted workbook: check the Recycle Bin or cloud recycle options rather than AutoRecover.

A workbook’s location is one of the first details to confirm because recovery tools do not all access the same data source.

Recover files stored in OneDrive or SharePoint

Files saved through OneDrive or SharePoint have an additional recovery path because these services can keep previous versions of cloud-stored documents.

Open the file location online, locate the workbook, and use Version History to review earlier saved versions. Choose the version from before the unwanted changes and restore or download it according to the available options.

Version History is different from AutoRecover. AutoRecover handles temporary Excel recovery states, while OneDrive and SharePoint Version History works with saved cloud versions.

If a workbook was synced online before the problem occurred, checking Version History can be more reliable than searching local temporary folders because it uses stored versions rather than unsaved session data.

Understand recovery limits after failed saves

Recovery tools can help in many situations, but they cannot recreate information that was never stored anywhere. Understanding the limits prevents repeated searches in places that cannot contain the missing data.

Checking options after clicking Don’t Save

Clicking Don’t Save removes the current unsaved editing session from the normal save flow. Recovery may still be possible in limited cases, but there is no guarantee that the discarded changes can be restored.

If you clicked Don’t Save, check these locations in order:

1. Look for an older saved copy of the workbook on your computer.
2. Check OneDrive or SharePoint Version History if the file was stored online.
3. Check AutoRecover and temporary file locations for any remaining recovery copy.

The diagnostic signal is whether another copy exists. If the workbook has no older saved version, no cloud history, and no temporary recovery file, Excel has no remaining source from which to restore the discarded changes.

Recognizing when recovery copies are unavailable

A recovery attempt usually ends when all available sources are empty: Excel recovery lists contain nothing, AutoRecover folders have no matching files, temporary folders contain no useful candidates, and cloud history has no earlier versions.

A missing recovery copy can happen because the workbook was never captured by AutoRecover, temporary files were removed, or the only copy was overwritten.

In that situation, the practical option is to recreate the lost information from other records, exports, email attachments, or notes if any exist.

Prevent future Excel file loss in Office 365

Recovery is easier when Excel has more than one place to retrieve information from. Office 365 includes settings and storage options that can reduce the impact of unexpected closures.

Configuring safer Excel recovery settings

Review Excel’s recovery settings by opening Excel options and checking the Save section. Confirm that AutoRecover is enabled and that Excel is saving recovery information.

For cloud-based workbooks, AutoSave can provide continuous saving behavior when the file is stored in supported locations such as OneDrive or SharePoint.

Backup copies can also provide another recovery route. Excel includes options for creating backup copies through save settings, but these must be configured before a loss occurs.

Using storage habits that protect workbooks

A few habits make future recovery easier:

• Save important workbooks in OneDrive or SharePoint when appropriate so Version History can provide earlier saved versions.
• Keep meaningful file names so recovered copies are easier to identify.
• Save major milestones as separate workbook versions when making significant changes.

Small changes to saving habits reduce dependence on temporary recovery files, which are designed as a safety feature rather than a replacement for normal saving.

Open Excel today and check File > Options > Save to confirm AutoRecover settings are enabled, because that creates a recovery path before the next unexpected closure removes your latest work.

FAQ

Can I recover an Excel file after clicking Don’t Save?

You may be able to recover an Excel file after clicking Don’t Save if another copy still exists. Check for an older saved workbook, OneDrive or SharePoint Version History, and AutoRecover or temporary file locations. Recovery is not guaranteed because Excel can only restore information that was preserved in a recovery copy or saved version.

How long do AutoRecover Excel files remain available?

AutoRecover files remain available only while Excel keeps a usable temporary recovery copy. Their availability depends on whether Excel captured recovery information before closing and whether the temporary files are still present. If no recovery copy exists in Excel’s recovery options or folders, there may be nothing available to restore.

Can I recover an Excel file that was permanently deleted?

A permanently deleted Excel file may still have recovery options if another copy exists. Check locations such as OneDrive or SharePoint history, the Recycle Bin when applicable, and other saved or temporary copies. AutoRecover is intended for unsaved work and may not help if the file itself was removed.

Does AutoSave replace AutoRecover in Excel 365?

No. AutoSave and AutoRecover serve different purposes in Excel 365. AutoRecover creates temporary recovery information for crashes or unexpected closures, while AutoSave continuously saves changes for supported files stored in locations such as OneDrive or SharePoint.