7 Ways To Recover Unsaved Microsoft Excel Files
Losing an Excel workbook before saving it can be frustrating, especially when you have spent hours entering data, creating formulas, or formatting a spreadsheet.
The good news is that Microsoft Excel includes several recovery features that may help you restore an unsaved or accidentally closed workbook.
Excel can temporarily store information through AutoRecover, and Windows may also retain temporary versions of files.
Depending on what happened, you may be able to recover your work directly from Excel, locate a temporary file, or restore an earlier version.
In this guide, I have explained 7 ways to recover unsaved Microsoft Excel files in an easy way, along with some alternative methods.
7 Ways To Recover Unsaved Microsoft Excel Files
1: Use Excel’s Recover Unsaved Workbooks Feature
The easiest method is to check Excel’s Recover Unsaved Workbooks option. This feature is designed specifically for situations where you created or edited a workbook but closed Excel without saving it.
First, open Microsoft Excel from the Start menu or desktop. Once Excel opens, select File from the upper-left corner. You will see Excel’s Backstage view.
Select Info, and then look for Manage Workbook. Depending on your Excel version, you may see an option called Recover Unsaved Workbooks.
Select this option. Excel will open a folder containing workbooks that may still be available for recovery.
Look through the files and identify the workbook you were working on. If you are unsure which file is yours, check the date and time associated with the files.
Open the most likely file. If it contains your missing work, immediately select Save As and save it to a normal folder such as Documents.
This method is particularly useful when Excel closes unexpectedly or you accidentally select Don’t Save.
2: Check Excel’s AutoRecover Files
Excel’s AutoRecover feature periodically saves temporary information about open workbooks. If Excel crashes, shuts down unexpectedly, or your computer restarts, AutoRecover may have a recent copy.
Open Excel and select File > Options. In the Excel Options window, select Save.
Look for the section named AutoRecover file location. You will see a folder path where Excel stores AutoRecover information.
Copy that folder path and paste it into File Explorer’s address bar. Press Enter to open the location.
Look for files created around the time you lost your workbook. Open a likely file with Excel and check whether your missing information is present.
If you successfully recover the workbook, use Save As to create a permanent copy.
Keep in mind that AutoRecover does not necessarily contain every recent change. The available version depends on when Excel last created an AutoRecover copy.
3: Look for Excel Temporary Files
Another option is to search for temporary Excel files. Windows and Microsoft Office can create temporary files while you work on documents.
Press Windows + R on your keyboard to open the Run dialog box. Enter %temp% and press Enter.
Windows will open your temporary files folder. Search for files that were created around the time you were working on the spreadsheet.
You can also use File Explorer’s search box and search for terms such as .tmp. If you find a potentially relevant file, make a copy of it before experimenting with it.
Temporary files can have confusing names, so you may need to check several files. Not every temporary file is a recoverable Excel workbook, but this method can help when the normal recovery option does not work.
4: Check the Document Recovery Pane
If Excel recently crashed or was forced to close, it may automatically display the Document Recovery pane the next time you start the program.
Close and reopen Excel. If recovery information is available, a Document Recovery pane may appear on the left side of the window.
You may see one or more versions of your workbook listed there. Each entry can include the file name and the time it was recovered.
Select the most recent version and inspect the workbook carefully. If it contains your missing work, save it immediately using File > Save As.
Do not assume that the newest-looking file is always the best version. Open the available versions and compare the information if several recovery copies are displayed.
5: Restore a Previous Version of the Workbook
If you had already saved the Excel file at least once, but later lost changes, you may be able to restore an earlier version.
Find the original Excel workbook in File Explorer. Right-click the file and select Properties.
If Windows has previous versions available, select the Previous Versions tab. You may see older copies of the file.
Select a suitable version and choose Open if you want to inspect it before replacing anything.
If the version contains the information you need, use the appropriate restore or copy option. It is safer to copy the recovered version to another location first so that you do not accidentally overwrite your current file.
This method is most useful for workbooks that were previously saved and later changed or damaged.
6: Check OneDrive or SharePoint Version History
If your Excel workbook is stored in OneDrive or SharePoint, you may have another recovery option through version history.
Open the location where the workbook is stored and locate the Excel file. Right-click the file or use the available file options, then look for Version History.
A list of previous versions may appear. Select an earlier version to inspect it.
If the missing data is present, restore that version or save a copy of it. Version history can be especially helpful when you accidentally overwrite a workbook or delete important changes.
This method is different from AutoRecover because the earlier version is associated with the cloud-stored file rather than only with Excel’s temporary recovery system.
7: Search Your Computer for the Missing Excel File
Sometimes the workbook was actually saved, but it was saved in a different folder than you expected. Before assuming the file is permanently lost, perform a thorough Windows search.
Open File Explorer and select This PC. In the search box, enter *.xlsx and press Enter.
Windows will search for Excel workbooks with the .xlsx extension. If you commonly use older Excel formats, also search for *.xls.
Sort the results by Date modified. This makes it easier to identify files created or changed around the time you were working on the missing spreadsheet.
Open likely files and check their contents. If you find the correct workbook, save another copy in an easy-to-find location.
This simple method is often overlooked because users assume an unsaved file cannot exist anywhere. In reality, you may have saved it earlier without remembering the exact folder.
Other Alternative Methods
Check the Recycle Bin
If you accidentally deleted an Excel workbook, open the Recycle Bin on the Windows desktop. Search for the file by name or look through recently deleted files.
If you find it, right-click the workbook and select Restore. Windows will return the file to its previous location.
Check Your Email Attachments
If you previously sent the workbook to someone through email, check your Sent folder and search for the Excel attachment. You may be able to download the attached copy and continue working from there.
This can also help when the original workbook was accidentally deleted from your computer.
Search Other Cloud Storage Locations
If you use cloud storage services, check the folders where you normally keep documents. A missing workbook could have been automatically synchronized to another device or folder.
Look at recent files, deleted files, and version history where those features are available.
How to Prevent Losing Excel Work Again
The best recovery method is prevention. Open Excel and go to File > Options > Save. Make sure AutoRecover is enabled and choose a suitable recovery interval.
You should also save important workbooks regularly by pressing Ctrl + S. For important projects, consider keeping a second copy in another folder or cloud storage location.
When working on a new workbook, save it early rather than waiting until the entire spreadsheet is complete.
Giving the file a proper name and location makes later recovery much easier.
FAQs
Can I recover an Excel file that I never saved?
Yes, sometimes. Use Recover Unsaved Workbooks, check the AutoRecover location, and search temporary files. Recovery is not guaranteed because Excel may not have created a usable recovery copy.
Where does Excel save AutoRecover files?
Excel displays the AutoRecover file location under File > Options > Save. You can copy that folder path and open it in File Explorer.
Can I recover an Excel file after clicking Don’t Save?
Possibly. Immediately check File > Info > Manage Workbook > Recover Unsaved Workbooks. If Excel retained a recovery copy, it may appear there.
How often does Excel AutoRecover my work?
The AutoRecover interval depends on your Excel settings. You can view and change the interval under File > Options > Save.
Can I recover an Excel file after my computer crashes?
Yes, there is a possibility. Reopen Excel and check the Document Recovery pane. You should also check Recover Unsaved Workbooks if the recovery pane does not appear.
Summary
Recovering an unsaved Microsoft Excel file is possible in many situations, but success depends on whether Excel or Windows retained a temporary or previous copy.
Start with Recover Unsaved Workbooks, then check AutoRecover files, temporary files, Document Recovery, previous versions, cloud version history, and Windows search.
For future work, keep AutoRecover enabled, save important spreadsheets frequently, and maintain another copy of critical workbooks.