You have saved an Excel file, overwriting the old version with unwanted changes. This can happen after accidental edits, formula errors, or data deletion. Excel and Windows provide several built-in methods to retrieve older file versions. This article explains how to use AutoRecover, File History, and OneDrive to restore your work.
Key Takeaways: Recovering Overwritten Excel Files
- File > Info > Manage Workbook: Restores an unsaved or AutoRecovered version from within Excel.
- File Explorer > Right-click file > Restore previous versions: Accesses versions saved by Windows File History or system restore points.
- OneDrive website > File version history: Recovers any prior version saved to the cloud from the last 30 days.
Understanding Excel’s Version Recovery Features
Excel does not have a single undo history that persists after closing a file. Recovering a version from before the last save requires using one of three backup systems. The method you use depends on where the file was stored and which features were enabled.
AutoRecover creates temporary backup copies at set intervals while you work. File History in Windows 10 and 11 automatically backs up files in designated folders to an external drive or network location. OneDrive and other cloud services keep a version history for files stored in their sync folders. You must have one of these systems active before the file was overwritten to recover it.
Prerequisites for Recovery
AutoRecover is usually on by default. Check its settings in File > Options > Save. The save interval is typically 10 minutes. File History must be set up manually in Windows Settings > Update & Security > Backup. OneDrive version history is automatic for files saved in your OneDrive folder.
Steps to Restore a Previous Version
Method 1: Use Excel’s Manage Workbook Feature
This method works for unsaved files or AutoRecover versions from the current session.
- Open Excel and go to File > Open
Click Recent on the left. Scroll to the bottom and click Recover Unsaved Workbooks. - Browse the UnsavedFiles folder
A File Explorer window opens showing AutoRecover files. Look for your file by name or date. - Open and save the recovered file
Double-click the file to open it in Excel. Immediately use File > Save As to save it with a new name.
Method 2: Use Windows File History or Restore Previous Versions
This works if File History is configured or if Windows created a restore point.
- Navigate to the file in File Explorer
Find the overwritten Excel file on your computer. - Right-click the file and select Properties
In the dialog box, click the Previous Versions tab. - Select a version to restore
A list of older versions from File History or restore points appears. Select the version from before the overwrite. - Click Restore
Click the Restore button. Confirm to replace the current file or choose Restore To to save it elsewhere.
Method 3: Use OneDrive Version History
This method is for files stored in your OneDrive folder.
- Go to the OneDrive website
Sign in to onedrive.live.com with your Microsoft account. - Locate and select your Excel file
Navigate through the folders and click once on the overwritten file. - Open the version history menu
Click Version history in the top menu bar. A panel opens on the right. - Preview and restore a version
Click a previous version to preview it. Click Restore to make it the current version. OneDrive saves the overwritten version as a new entry in the history.
Common Mistakes and Limitations
AutoRecover File Not Found
AutoRecover files are deleted when Excel closes normally. They are only available if Excel crashed or was closed unexpectedly. Always check the AutoRecover file location in File > Options > Save to know where to look.
Previous Versions Tab is Empty
The Previous Versions tab will be empty if File History was never set up or if the file is not in a folder included in the backup. System restore points do not always capture individual document versions. This method requires proactive setup.
OneDrive File is Not Syncing
If the file was saved locally and not in the OneDrive folder, it will not have a cloud version history. Check the file icon in File Explorer. A green checkmark means it is synced. A blue cloud icon means it is online-only and may not have local backups.
Recovery Method Comparison
| Item | Excel AutoRecover | Windows File History | OneDrive Version History |
|---|---|---|---|
| Primary Use Case | Recover unsaved work after a crash | Restore files from system backups | Recover overwritten cloud-synced files |
| Setup Required | Enabled by default in Excel options | Manual setup in Windows Backup settings | Automatic for files in OneDrive folder |
| Version Retention | Temporary, until Excel closes | Depends on backup drive capacity | Last 30 days for all file types |
| Access Method | File > Info > Manage Workbook in Excel | File Explorer right-click > Restore previous versions | OneDrive website > Version history menu |
| File Location | Local unsaved files folder | External drive or network location | Microsoft cloud servers |
You can now recover an Excel file from before your last save. Use the Manage Workbook option for recent unsaved work. For older versions, check File History or OneDrive. A concrete advanced tip is to set File History to back up your main Documents folder to an external drive weekly. This creates a reliable local backup independent of cloud services.