If an Excel workbook seems gone, first check Excel’s Recent list, search your computer for its filename, and look in the Windows Recycle Bin or your OneDrive recycle bin. If you closed it without saving, try Excel’s recovery options immediately; they can restore only a copy Excel actually saved, so recovery is not guaranteed.
First, work out what “gone” means
A missing workbook can mean several different things: the file was moved or renamed, it was deleted, an unsaved version was lost, or Excel is open but the workbook window is hidden. Sometimes the file opens but its worksheets or data appear missing. These situations call for different fixes, so avoid saving over a file or making broad changes until you know which one applies.
Think about what happened just before you noticed the problem. Did you close Excel, restart the computer, click Delete, move folders, switch Microsoft accounts, or open a file from an email attachment? A workbook saved to a temporary attachment folder may not be where you expect, and a workbook stored in OneDrive may be associated with a different account than the one currently signed in.
If Excel is still open, don’t close it yet. Look through the open windows and check whether the workbook is listed under the Excel icon on the Windows taskbar. If you have unsaved work in another open workbook, save that work before troubleshooting. If the missing file is in a shared folder, ask whether another person renamed, moved, or deleted it.
Check Excel’s Recent list and open windows
In Excel for Microsoft 365 on Windows, select File > Open > Recent. The list shows files you opened recently, but it is a shortcut list, not a complete inventory of every workbook on your computer. If you see the file, select it. If Excel reports that it cannot find the file, the entry may point to a file that has been moved, renamed, or deleted.
Also check whether the workbook window itself is hidden. Select View > Unhide. If Excel lists a workbook in the dialog, select it and choose OK. This restores a hidden workbook window; it does not recover a deleted file. If Unhide is unavailable or the dialog has no workbook listed, this is probably not the issue.
A hidden worksheet is different from a hidden workbook window. If the workbook is open but a tab is missing, right-click a visible sheet tab and select Unhide. Choose a sheet from the list if one is available. A worksheet that is hidden will not appear as a separate file in File Explorer, because it is still part of the open workbook.
Recover a workbook that was never saved
If Excel closed unexpectedly or you chose not to save, look for an unsaved recovery copy. In Excel for Microsoft 365 on Windows, try File > Info > Manage Workbook > Recover Unsaved Workbooks. In some Excel builds, the recovery option is also available from File > Open > Recent, near the bottom of the page. Open any promising file and save it promptly with File > Save As to a known folder.
Excel’s AutoRecover feature periodically saves recovery information while you work, but it is not the same as saving the workbook normally. Whether a usable recovery copy exists depends on settings, timing, and how Excel closed. A crash may leave a recovery copy; a workbook that was never saved may have no recovery copy at all. AutoSave is also distinct: it is designed to save changes continuously for eligible files stored in OneDrive or SharePoint, while AutoRecover is intended to help after an interruption.
If the recovery option shows nothing, you can check the AutoRecover folder location in File > Options > Save. The location varies by installation and configuration. Use the location shown there rather than assuming a particular folder path. Do not rename or delete unfamiliar recovery files while searching; make a copy first and try opening the copy in Excel. Recovery files may be incomplete or out of date.
On a Mac, check Excel’s File > Open Recent list and any recovery prompt shown when Excel restarts. The exact recovery interface and file locations differ from Windows, so Windows menu paths and folder instructions do not necessarily apply. For Excel for the web, check the OneDrive or SharePoint folder where the workbook was stored and review its version history.
Look in OneDrive, SharePoint, and version history
If the workbook was saved to OneDrive or a SharePoint library, confirm that you are signed in to the right Microsoft account and viewing the right folder. A file can disappear from a local folder if OneDrive is not syncing, if you are looking at a different account, or if the file was moved within the cloud location. Check the service in a web browser as well as the synced folder in File Explorer.
For a cloud file that still exists but has lost recent changes, use version history. In Excel, try File > Info > Version History when that option is available. You can also find the workbook in OneDrive or SharePoint, open its context menu, and choose Version history. Review dates and versions before restoring anything. If you are unsure, download or save a copy of the current version first; restoring an older version can replace the current file contents.
Deleted cloud files may be in the OneDrive recycle bin or the SharePoint site’s recycle bin, depending on where the workbook was stored and how it was deleted. Open the relevant service in a browser, locate its recycle bin, select the file, and choose Restore if it is listed. Availability and retention depend on the account and organization’s policies. For a work or school account, an administrator may control retention or have additional recovery options.
Search Windows and check the Recycle Bin
When Recent does not help, search beyond the folder where you expected the workbook. Press Windows key + E to open File Explorer, select This PC, and search for part of the filename. If you do not remember the name, search for common Excel file extensions such as *.xlsx, *.xlsm, or *.xlsb. Older Excel workbooks may use *.xls. Search results can take time, especially on a large drive.
Sort results by date modified and inspect likely folders, including Documents, Desktop, Downloads, and folders used for work projects. Check whether the file was saved under a slightly different name or extension. If you opened it from an email or messaging app, search the folder where attachments are downloaded, then save any recovered copy to a permanent folder.
Open the Windows Recycle Bin from the desktop and search or sort by deletion date. If you find the workbook, right-click it and choose Restore; Windows normally returns it to its original location. If the Recycle Bin was emptied, the file was deleted from a removable drive, or the file lived only in a cloud service, this check may not help. Check the cloud recycle bin separately for OneDrive or SharePoint files.
If you use a work-managed computer, a network drive, or a backup service, ask the IT team or the service administrator about available backups before using third-party recovery software. Stop writing new files to a drive if you suspect a permanently deleted local file and the data is important: new activity can reduce the chance that deleted data remains recoverable. Do not assume recovery software can restore a complete, usable workbook.
When the workbook opens but looks empty or damaged
A workbook that opens to a blank-looking screen may not be deleted. Check whether another workbook window is active, whether the sheet tabs are hidden, and whether the workbook contains hidden sheets. You can also use View > Unhide for a hidden workbook window. If a sheet is visible but its data appears absent, check the sheet’s scroll position and whether rows or columns are hidden before concluding that the contents were erased.
If the file exists but Excel says it is damaged or cannot open it normally, try Excel’s built-in repair option. Select File > Open > Browse, locate and select the workbook, then select the arrow beside the Open button and choose Open and Repair. Choose repair when offered. This option is for a file that exists but may be corrupted; it cannot locate a missing workbook or recreate changes that were never saved.
For a workbook that opens with missing recent edits, first check OneDrive or SharePoint version history and any AutoRecover copy. Avoid repeatedly saving over the only remaining version. Save a separate copy under a new name before trying repairs or comparing older versions. If the workbook is on a shared drive, confirm that you are opening the correct copy rather than an older duplicate.
Recover carefully and avoid overwriting the only copy
Once you find a candidate workbook, check its folder, filename, file size, and modified date before replacing anything. Open it and confirm that the expected worksheets and recent data are present. If it is an older version, preserve it separately while you compare it with the current copy. A recovered file can be incomplete, especially if Excel or the computer stopped while saving.
- Save a recovered or repaired file to a new name or folder first.
- Keep the original file unchanged until you have confirmed the recovered copy is usable.
- For cloud files, check version history before restoring an older version.
- Do not enable macros just to inspect a workbook unless you trust its source and need its macro features.
- If the workbook contains confidential work data, use approved company storage and recovery support rather than uploading it to an unfamiliar service.
If the workbook was permanently deleted and there is no backup or cloud version, recovery may not be possible. For important business files, contact your organization’s IT support promptly; they may have backups or retention tools unavailable to ordinary users. For personal files, check any backup service or external drive you used before assuming the file is gone for good.
Prevent the next missing-workbook scare
Save important workbooks in a consistent, backed-up location and use a clear filename. For example, a team might keep a monthly report in a dedicated OneDrive or SharePoint project folder rather than leaving copies in Downloads, email attachments, and the desktop. Cloud storage can provide syncing and version history, but it is not a reason to skip checking that the file has finished syncing or that you are signed in to the correct account.
Use File > Save As when creating a new workbook so you know where its permanent copy will live. For files stored locally, maintain a separate backup on a location managed for backups; a second copy on the same drive may be lost in the same failure. For shared workbooks, agree on a single source of truth and avoid confusing duplicate names such as Report final, Report final 2, and Report latest.
AutoRecover settings are worth reviewing in File > Options > Save. The interval and options available may vary, and AutoRecover should be treated as a safety net rather than a substitute for saving. Press Ctrl+S regularly on Windows. On Mac, use Command+S. If you deleted text or a worksheet during the current session, Ctrl+Z on Windows or Command+Z on Mac may undo the action, but undo is not a dependable way to restore a file after closing Excel.
Frequently Asked Questions
Can I recover an Excel file I never saved?
Maybe. In Excel for Microsoft 365 on Windows, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel created a recovery copy before it closed; there may be nothing to restore.
Where does Excel save AutoRecover files?
The location can vary. In Windows Excel, view the current location under File > Options > Save. Use the folder shown in your own settings rather than relying on a generic path, and copy any candidate file before attempting recovery.
Why is my workbook missing from Recent?
Recent lists files you opened, not every workbook you own. The file may have been moved, renamed, deleted, or opened under a different Microsoft account. Search File Explorer and the relevant OneDrive or SharePoint folder directly.
Can I get back an Excel workbook deleted from OneDrive?
Check the OneDrive recycle bin in a browser and restore the workbook if it is there. If the file was in SharePoint, check that site’s recycle bin. Retention and recovery options depend on the account and organization’s policies.
Why does my workbook open with missing sheets?
The sheets may be hidden rather than deleted. Right-click a visible sheet tab and select Unhide to see whether Excel lists hidden sheets. If the missing sheets are not listed, check an older workbook version or backup before editing the only copy.
Related
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Copied Formula Not Working in Excel? Fix ItIf a copied formula is not working in Excel, first check whether the reference changed as intended, the…
- Excel Cell Won’t Change Color? Find the FixIf an Excel cell won’t change color, check whether Conditional Formatting is controlling its fill; a rule can…
- Why Am I Getting a #REF! Error in Excel?You are getting a #REF! error because an Excel formula contains a reference that is no longer valid,…
- Excel Not Filling Sequential Numbers? Fix the SeriesIf Excel repeats a number instead of counting, enter the first two numbers, select both cells, and drag…
- Excel Spill Error: Causes and Ways to Fix ItThe Excel #SPILL! error means a formula is trying to return results into multiple cells, but Excel cannot…
- Circular Reference Error in Excel: How to Find It FastTo find a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.