You cannot find an Excel file you were just working on. This often happens after a crash, an accidental close, or when saving to an unexpected location. Excel and Windows keep multiple records of your recent work. This article explains how to search these records to recover your lost file.
Key Takeaways: How to Find a Lost Excel File
- File > Open > Recent: Shows the last 50 files you worked on, including unsaved workbooks.
- Windows File History: Recovers previous versions of files saved to a specific drive or network location.
- Windows Search (Win + S): Searches your entire computer for file names and content, including temporary files.
Where Excel and Windows Store File Information
Excel does not automatically save every file to a default folder like Documents. Files can be saved to cloud storage, external drives, or temporary project folders. To help you find them, Excel maintains a list of recently opened files and their locations. Windows also has built-in tools that track file changes over time. The File History feature creates backup copies of files in libraries, desktop, and contacts. Understanding these two systems is key to locating a lost workbook.
Excel’s Recent Documents List
The Recent list is the fastest way to find a file you opened recently. It is stored within Excel’s application settings and is independent of your Windows search index. This list shows file names, thumbnail previews, and the full folder path. It also includes a separate section for workbooks you closed without saving. The list updates each time you open or save a file, but older entries are removed after you open 50 newer files.
Windows File History
File History is a backup feature in Windows 10 and Windows 11. It must be set up in advance to work. When enabled, it automatically saves copies of your files to an external drive or network location every hour. It does not back up every file on your PC, only those in your user folders. If you saved your Excel file to the Documents, Pictures, or Desktop folder, File History may have a previous version you can restore.
Steps to Search for Your Lost Excel File
Method 1: Check Excel’s Recent List and Recover Unsaved Workbooks
- Open Excel to a blank workbook
Launch Excel from the Start menu or taskbar. Do not open any existing file. - Go to File > Open
Click the File tab in the top-left corner of the Excel window. Then select Open from the left-hand menu. - Review the Recent list
On the right side, you will see a list labeled “Recent”. Scroll through this list to find your file. You can pin important files here by clicking the pushpin icon. - Check for unsaved workbooks
At the bottom of the Recent list, click “Recover Unsaved Workbooks”. This opens a system folder where Excel stores temporary copies of files closed without saving.
Method 2: Use Windows Search to Find the File
- Press Win + S on your keyboard
This opens the Windows Search box. You can also click the search icon on the taskbar. - Type part of the file name
Enter the name of your Excel file, or keywords you remember from its content. Ensure the search filter is set to “All”. - Filter the search results
Click the “Documents” filter above the results to narrow the list. Look for files with the .xlsx, .xls, or .xlsm extension. - Open the file location
Right-click the correct file in the search results and select “Open file location”. This shows you where the file is saved so you can note it for the future.
Method 3: Restore a Previous Version with File History
- Navigate to the folder where the file was saved
Open File Explorer and go to the folder you think contained the lost file, such as Documents. - Right-click the folder and select Properties
If the file itself is missing, right-click its parent folder. Choose Properties from the context menu. - Go to the Previous Versions tab
In the Properties dialog box, click the “Previous Versions” tab. This list shows backups created by File History or System Restore. - Select a version and click Restore
Choose a version from before the file was lost. Click the Restore button to copy that older version back to its original location.
Common Mistakes When Searching for Lost Files
Searching Only by Exact File Name
If you misremember the file name, an exact search will fail. Use partial names or search by file type. In Windows Search, you can type “*.xlsx” to see all Excel files. Also search for terms you typed in the workbook, as Windows indexes file content.
Assuming File History is Always On
File History is not enabled by default. You must connect a backup drive and turn it on in Settings > Update & Security > Backup. If you never set it up, the Previous Versions tab will be empty. For future files, enable this feature now.
Not Checking Temporary and AutoRecover Folders
Excel saves AutoRecover files every 10 minutes. To find them, go to File > Options > Save. The “AutoRecover file location” path shows where these temporary files are stored. Navigate to that folder in File Explorer to look for unsaved backups.
Excel Recent List vs. Windows File History: Key Differences
| Item | Excel Recent List | Windows File History |
|---|---|---|
| Primary Purpose | Quick access to recently opened files | Versioned backup and recovery |
| Data Stored | File names and paths only | Complete file contents |
| Setup Required | None, works automatically | Must be manually configured |
| Retention Limit | Last 50 files | Depends on backup drive space |
| Recovery Scope | Files you opened in Excel | Files in user folders (Documents, Desktop) |
| Access Method | File > Open > Recent within Excel | File Explorer folder Properties |
You can now locate a lost Excel file using the Recent list or Windows File History. Set up File History today to protect future work from accidental loss. For advanced recovery, use the AutoRecover file location in File > Options > Save to manually browse temporary backup files.