You saved an Excel file and accidentally overwrote the previous version with unwanted changes. This can happen when you click Save instead of Save As, or when a macro automatically saves the workbook. The original data seems lost. Windows File History is a built-in backup feature that can restore previous versions of your files. This article explains how to use it to recover an overwritten Excel workbook.
Key Takeaways: Recovering an Overwritten Excel File
- File History in Windows Settings: Navigate to the file’s location to browse and restore versions from a specific date and time.
- Right-click > Restore previous versions: Access older file versions directly from File Explorer if File History is active for that folder.
- Restore to a different location: Prevents accidentally overwriting your current file again during the recovery process.
How Windows File History Protects Your Files
Windows File History is a continuous backup tool. Once set up, it automatically saves copies of files in your Documents, Pictures, and Desktop folders to an external drive or network location. It does not back up every single save action. Instead, it saves versions of files at regular intervals, typically every hour by default. This creates a timeline of file versions you can browse.
For File History to have a copy of your overwritten Excel file, the feature must have been enabled and configured before the accident occurred. It also must have been backing up the folder where your Excel file is stored. File History does not protect files stored in all locations by default. You need to check its status and which folders are included.
Prerequisites for Recovery
You need two things to recover a file. First, File History must have been turned on. Second, the external drive or network location you used for backups must be connected to your PC. If you are using a laptop, ensure the external backup drive is plugged in. The recovery process will not work if the backup destination is unavailable.
Steps to Restore a Previous Version of an Excel File
Follow these steps to find and restore an older version of your workbook from a File History backup.
- Open File Explorer and navigate to the file’s folder
Go to the folder where your current, overwritten Excel file is saved. This could be your Documents folder or another location. - Click the Home tab on the ribbon, then select History
In the File Explorer window, click the Home tab in the top menu. In the Open section, click the History button. This opens the File History interface. - Browse the backup timeline
File History will show the contents of the selected folder. Use the left and right arrow buttons at the bottom to navigate through different backup dates and times. Find a point in time from before you saved over the file. - Preview and select the correct file version
Locate your Excel file in the backup window. You can select it and click the green Restore button in the center to replace the current file. For safety, right-click the file and choose Restore to. This lets you save it with a different name or to a different folder. - Open the recovered file in Excel
Navigate to the location where you saved the recovered version. Double-click the file to open it in Excel and verify your data is correct.
Alternative Method: Restore Previous Versions
If File History is active for a folder, you can also use a quicker method.
- Right-click the overwritten Excel file in File Explorer
Navigate to the file, right-click on it, and select Restore previous versions from the context menu. - Choose a version from the File History tab
A properties window will open. Click the File History tab. You will see a list of previous versions available from your backups. Select the version you want. - Click Restore
Click the Restore button. A dialog will ask if you want to replace the current file. To avoid another overwrite, click Restore and then choose to restore the file to a different location.
Common Mistakes and Limitations to Avoid
File History Was Never Turned On
If you open the History button and see a message to turn on File History, no backups exist. You cannot recover overwritten files with this tool. In this case, check if you have other backups, like OneDrive version history or a system restore point.
Backup Drive Is Not Connected
File History requires the backup drive to be connected. If you use an external USB drive for backups and it is not plugged in, the History button will show an error. Connect the correct drive and try the steps again.
File Was Saved in a Non-Backed-Up Location
By default, File History backs up only user folders like Documents and Desktop. If your Excel file was saved directly on the C: drive or in a program files folder, it likely was not backed up. You can add folders to File History in its settings.
Restoring Overwrites the Current File Again
Clicking Restore without using Restore to will replace the file in its current location. If you are unsure which version is correct, always use Restore to and save the old version with a new name. This keeps both files for comparison.
File History vs. OneDrive Version History
| Item | Windows File History | OneDrive Version History |
|---|---|---|
| Backup location | External drive or network folder | Microsoft cloud storage |
| Access method | File Explorer History or right-click menu | OneDrive website or right-click menu in File Explorer |
| Automation | Runs when backup drive is connected | Continuous when file is in OneDrive folder and synced |
| Version retention | Depends on drive space and settings | Keeps multiple versions for 30 days by default |
| Primary use case | Local disaster recovery and file versioning | Recovery from any device and collaboration rollback |
You can now recover an Excel file you saved over by using the File History feature. Always use the Restore to option to save the old version separately. For future protection, ensure File History is enabled and your backup drive stays connected. Consider saving important workbooks to a OneDrive synced folder for an additional cloud-based version history.