A Microsoft file hosting and synchronization service.
Immediately pause OneDrive syncing and copy the computer-name workbook—and any other candidate copies—to a folder outside OneDrive before attempting recovery, so the remaining local files are not replaced during synchronization.^1^
1. Protect and inspect local copies
- Select the OneDrive cloud icon in the Windows notification area.
- Select Help & Settings → Pause syncing.
- Create a folder outside OneDrive, such as
C:\Recovered Excel. - Copy, rather than move, the computer-name version into that folder.
- Open the copied file and check its worksheets. Do not delete or overwrite the original candidate yet.
On the affected PC, open File Explorer → This PC and search separately for:
- Part of the original filename
-
*.xlsx -
*.xlsm -
*.xlsb
Sort the results by Date modified, looking particularly around the last date when the workbook contained the expected data. A full-PC search can locate files outside the normal OneDrive folder or saved under another Excel extension.^2^
Also check Excel → File → Open → Recent. If the workbook appears, right-click it and use Open file location where available.
2. Try Excel’s recovery copy
Because the workbook was open during the incident, Excel may have retained an AutoRecover version:
- Open Excel.
- Select File → Info.
- Select Manage Workbook.
- Look for a version marked “when I closed without saving.”
- If one exists, open it and use Save As to save it into
C:\Recovered Excel.
Also select File → Info → Manage Workbook → Recover Unsaved Workbooks and inspect any files dated around the incident. Microsoft documents both recovery paths for Excel for Microsoft 365 and supported perpetual versions.^3^
3. Restore OneDrive to before the incident
Since neither recycle bin contains the workbook, the strongest cloud recovery option is a point-in-time OneDrive restore. This requires an active Microsoft 365 subscription and can roll OneDrive back to a point within the previous 30 days.^4^
- Sign in to the OneDrive website.
- For a personal account, select Settings → Options → Restore your OneDrive.
For a work or school account, select Settings → Restore OneDrive. - Choose a custom date and time immediately before the file disappeared.
- Review the activity chart and feed for deletion, rename, move, or overwrite activity involving the workbook.
- Select Restore.
Caution: this rolls back changes across the whole OneDrive, not just this workbook. Files created after the chosen restore point are moved to the OneDrive recycle bin. Keep sync paused and preserve any current files you need before proceeding. The restoration itself can be undone by running Restore your OneDrive again and selecting the previous restore action.^4^
If the original workbook becomes visible without performing a whole-drive rollback, right-click it on the OneDrive website and select Version history. Choose the required version’s … menu and select Restore. OneDrive version history supports Excel and other file types; documented retention is 30 days, although a work or school administrator may have disabled versioning.^5^
4. If it is a work or school OneDrive
Contact the organization’s Microsoft 365 administrator promptly and provide:
- Exact or approximate filename
- Folder where it was stored
- Approximate last-known-good date and time
- The PC on which it was last edited
- Whether it was owned by you or shared by someone else
For work or school accounts, an administrator may be able to investigate further when search and the visible recycle bin do not locate the file.^6^
If none of these locations contains a current copy and the file was permanently removed from the OneDrive recycle bin, Microsoft states that OneDrive’s restore feature cannot recover that permanently deleted item.^4^
References
- How to fix OneDrive files that reverted to earlier version - Microsoft Q&A
- lost excel file - Microsoft Q&A
- Recover an earlier version of an Office file | Microsoft Support
- Restore your OneDrive
- Restore a previous version of a file stored in OneDrive | Microsoft Support
- Find lost or missing files in OneDrive