Version History Issues

Recover an Unsaved Excel Workbook Using AutoRecover or Version History

Muhammad TalhaMuhammad Talha Nov 22, 2026 868 views

Question details

The user needs to recover a day's work in an Excel workbook after reverting to a previous state and closing without saving.

Recover an Unsaved Excel Workbook Using AutoRecover or Version History
Product
Microsoft Excel
Device & OS
not provided
Scenario
The workbook was reverted to a previous state and then closed without saving.
Observed behavior
The day's changes were lost, and the temporary-file folders checked afterward were empty.
Before you start

Identify whether the workbook was stored locally, in OneDrive, or in SharePoint. If you find a recovery candidate, open it and use Save As to preserve a separate copy.

Solution 1Recommended

Check Excel AutoRecover and unsaved workbook locations

Look for an AutoRecover copy or an unsaved workbook that Excel retained.

Recovery files are more likely to remain after a crash or unexpected shutdown than after a normal close. A locally stored workbook closed without saving may not have a recoverable copy.

1
Check the recovery pane

Open Excel and look for a Document Recovery pane. If a recovered workbook appears, open it and choose File > Save As to save a separate copy.

2
Look for unsaved workbooks

In Excel, select File > Info > Manage Workbook > Recover Unsaved Workbooks. Open any relevant candidate and use Save As to keep it.

3
Check the AutoRecover location

In Excel for Windows, go to File > Options > Save and note the AutoRecover file location. Open that folder in File Explorer and look for a relevant recovery file.

4
Check the unsaved-files folder

On Windows, paste %localappdata%\Microsoft\Office\UnsavedFiles into the File Explorer address bar. Open any relevant file in Excel and save it under a new name.

Check Excel AutoRecover and unsaved workbook locations
Recovery is not guaranteed: If no relevant recovery file exists, Excel may not be able to restore changes discarded during a normal close.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files, although it cannot recover Excel changes that were never saved.

Open and edit Excel-compatible spreadsheetsCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel recover changes after I close a workbook without saving?

Sometimes, but recovery is not guaranteed. Check the Document Recovery pane and File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery files are more likely to remain after a crash than after a normal close.

Where does Excel store AutoRecover files on Windows?

In Excel, go to File > Options > Save and check the AutoRecover file location. You can also check %localappdata%\Microsoft\Office\UnsavedFiles in File Explorer for unsaved workbook candidates.

Can Version History recover work that was never saved?

Version History only provides available saved versions. Open the workbook from OneDrive or SharePoint, select Version History, and review the versions to see whether one contains the work.

What if the temporary and recovery folders are empty?

Check Version History if the workbook was stored in OneDrive or SharePoint. If no recovery file or saved version contains the changes, the discarded work may not be recoverable.