A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Since the Windows Recycle Bin and Excel’s Recent list did not contain the workbook, check Excel’s AutoRecover copies first, using the path that matches whether the file had ever been saved.
1. Recover the workbook from Excel
If the workbook was never saved:
- Open Excel.
- Select File → Info.
- Select Manage Workbook → Recover Unsaved Workbooks.
- Open the likely file, checking its date and time.
- Immediately select Save As and save it with a new name in a known folder. ^1^
If the workbook had been saved at least once and you lost the latest changes:
- Open the original workbook, if it is still available.
- Go to File → Info → Manage Workbook.
- Select the version marked (when I closed without saving).
- Select Restore. To preserve the existing copy, consider using Save As with a different filename first. ^1^
Also close and reopen Excel once. If Excel previously closed unexpectedly, the Document Recovery pane may appear. Open the copy with the latest date and time, review it, and select Save As. ^2^
AutoRecover files are periodically deleted, so perform these checks as soon as possible. ^3^
2. Check OneDrive separately
Microsoft 365 may save files to OneDrive when the user is signed in. Therefore, check OneDrive on the web even if the Windows Recycle Bin was empty:
- Sign in to OneDrive using the Microsoft account used in Excel.
- Search for the workbook by filename or part of its name.
- Check the My files, Documents, and Recycle Bin sections. The OneDrive Recycle Bin is separate from the Windows Recycle Bin.
- If the workbook exists but lacks recent work, right-click it and select Version history.
- Open the menu beside the required version and select Restore. ^4^
3. Search the entire PC
If no recovery copy exists, search all drives rather than only the usual folder:
- Open File Explorer and select This PC.
- Search separately for:
-
*.xlsx -
*.xls -
*.xlsm
-
- Sort the results by Date modified.
- Check Documents, Desktop, Downloads, external drives, and OneDrive folders.
A full This PC search can locate a workbook that was accidentally saved or moved to an unexpected folder. ^5^
4. Restore from Windows File History, if it was previously enabled
- In File Explorer, open the folder that previously contained the workbook.
- Right-click that folder and select Restore previous versions.
- Select a version from before the workbook disappeared.
- Choose Open in File History to inspect it.
- Use Restore to... and select another folder, avoiding replacement of current files. ^6^
If none of these locations contains the file, recovery may not be possible because Excel requires an AutoRecover copy, a saved cloud version, or an existing backup. For future work, save Excel files to OneDrive and enable File → Options → Save → Save AutoRecover information every and Keep the last AutoRecovered version if I close without saving.
References