First save a copy of the reverted workbook outside OneDrive, then check its Version History on the OneDrive website because versions may be available there even when none appear in Excel or File Explorer.
1. Protect the current file
In Excel, select File > Save a Copy and save it under a different name in a local, non-synced folder or on an external drive. Do not overwrite the current workbook while testing recovered copies.
2. Check OneDrive on the web
If the workbook is stored in OneDrive:
- Sign in to the OneDrive website with the same account used by Excel.
- Locate the workbook.
- Right-click it and select Version history.
- If an appropriate version appears, use its … menu and select Restore.
The restored version becomes current, while the previously current version remains in the version list. OneDrive version history is generally retained for 30 days; for work or school accounts, an administrator may have disabled versioning.^1^
Also check the OneDrive Recycle Bin for another copy that may have been deleted, renamed, or replaced.
3. Check Excel’s local recovery copies
If OneDrive web has no usable version:
- Open the affected workbook in Excel.
- Select File > Info.
- Under Manage Workbook, look for a version labeled (when I closed without saving).
- Open it and select Restore or, more safely, Save As with a new filename.
Also check:
- File > Info > Manage Workbook > Recover Unsaved Workbooks
- Open any promising file.
- Immediately select Save As and store it under a new name.
These options only help if Excel created and retained an AutoRecover copy.^2^
4. If it was in OneDrive, consider restoring the entire OneDrive
This is a fallback for a Microsoft 365 subscriber when the workbook was overwritten or corrupted within the last 30 days and file-level recovery is unavailable.
- First copy any recently created or changed files that must be preserved to a local non-synced folder or external drive.
- On the OneDrive website, open:
- Personal account: Settings > Options > Restore your OneDrive
- Work or school account: Settings > Restore OneDrive
- Select Custom date and time from before the workbook reverted.
- Review the activity feed carefully.
- Select Restore.
Caution: This affects the entire OneDrive, not only the workbook. Files created after the selected restore point are moved to the OneDrive Recycle Bin. The feature requires Microsoft 365 and covers actions within the previous 30 days.^3^
5. Check Windows backups
If the workbook was stored locally, or its OneDrive folder was protected by Windows File History:
- Open File Explorer and browse to the workbook’s folder.
- Right-click the file or containing folder.
- Select Restore previous versions.
- Select a version dated before the reversion.
- Use Restore to… and choose another folder rather than replacing the current file.
This works only if File History or another Windows backup had already captured that location. Direct restoration replaces the existing file and cannot be undone, so Restore to… is safer.^4^
If OneDrive web has no version, Excel has no AutoRecover copy, OneDrive Restore has no suitable restore point, and Windows has no previous version or other backup, Microsoft’s listed built-in recovery sources do not contain a newer recoverable copy.
References
- Restore a previous version of a file stored in OneDrive | Microsoft Support
- Recover an earlier version of an Office file | Microsoft Support
- Restore your OneDrive
- Backup and restore with File History | Microsoft Support