How to Recover an Overwritten Excel File When Version History is Missing
Question details
The user needs to recover an accidentally overwritten Excel workbook but cannot locate the earlier version in the standard Microsoft 365 version history.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to restore a previous iteration of an overwritten workbook stored locally, in OneDrive, or in SharePoint.
- Observed behavior
- The earlier version of the workbook does not appear in the Microsoft 365 version history, preventing standard cloud recovery.
Verify exactly where your Excel file was originally saved (locally on your hard drive, OneDrive, or a SharePoint folder) and avoid closing the application if the file is still open, as you might be able to simply use the 'Undo' function.
Recover from OneDrive or SharePoint Online
If your file is synced to the cloud, you can check the online version history directly through the web interface, which may display versions not visible in the desktop app.
Sometimes the desktop Excel application fails to load the complete version history. Accessing your OneDrive or SharePoint account via a web browser can reveal hidden or older file iterations.
Log in to your OneDrive or SharePoint account through your web browser.
Navigate to the folder containing the overwritten Excel workbook.
Right-click the file and select 'Version history' from the context menu.
Review the list of saved iterations by date and time. Click the three vertical dots next to the version you want back and select 'Restore'.
Restore Using Time Machine (Mac users)
For files saved locally on a macOS device rather than the cloud, you can recover overwritten files using Apple's built-in Time Machine backup.
Request a Backend Restoration (Microsoft 365 Business)
If version history is completely empty and no local backups exist, Microsoft 365 Business administrators can request Microsoft Support to perform a backend restoration.
Avoid Data Loss with WPS Office's Built-in Backup Features
Looking for a reliable alternative to Microsoft Excel? WPS Office provides seamless compatibility with Microsoft formats alongside robust local and cloud auto-backup capabilities to prevent accidental overwrites—all for free.
- 1. Download and Install: Visit the official WPS website and download the free WPS Office suite for your device.
- 2. Open your Spreadsheets: Launch WPS Office and open your existing Excel (.xlsx) files directly with zero formatting loss.
- 3. Enable Auto-Backup: Go to Menu > Settings > Backup Center to configure automatic local backups, ensuring you never lose overwritten data again.
Frequently Asked Questions
Can I undo an overwritten Excel file if I haven't closed it yet?
Yes, if the Excel file is still open, simply press Ctrl+Z (or Cmd+Z on Mac) repeatedly to undo the recent changes. Once you save and close the file, the undo history is cleared, and this method will no longer work.
Does Windows have a built-in feature like Mac's Time Machine for overwritten files?
Yes, Windows features 'File History' and 'Previous Versions'. If File History or System Restore was enabled beforehand, you can right-click the overwritten Excel file or its folder, select 'Restore previous versions', and choose an older backup to restore.
Why is my version history completely empty in Microsoft 365?
Version history requires the file to be actively synced to a cloud service like OneDrive or SharePoint with AutoSave enabled. If the file was only saved locally, or if your cloud syncing was paused, disconnected, or disabled, previous versions will not be tracked.
Where are temporary Excel files stored on Windows?
Excel often saves temporary AutoRecover files in 'C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles'. Checking this hidden folder may help you locate an unsaved or older temporary version of your workbook.
