'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Recover an Unsaved Excel File After a Crash
Question details
The user needs to recover an Excel workbook that was not saved before the application crashed unexpectedly.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- The application crashed while the user was working on a file, and they want to retrieve their lost data.
- Observed behavior
- The recent edits or the entire newly created file are missing upon reopening Excel, requiring the user to locate temporary backups or AutoRecover files.
Ensure you have not cleared your system's temporary files or run a PC optimization tool since the crash, as this could permanently delete the recoverable temp files.
Use Document Recovery or Recent Workbooks
The fastest way to recover your file is using Excel's built-in recovery pane or the UnsavedFiles folder.
When Excel closes unexpectedly, it typically attempts to recover your active workbooks the next time you open the application.
Reopen Excel. Look for the 'Document Recovery' pane on the left side of the screen. If present, click on the listed files to preview them, and save the correct one immediately.
If the recovery pane does not appear, click on 'File' in the top-left corner and select 'Open', then choose 'Recent'.
Scroll to the very bottom of your recent files list and click the 'Recover Unsaved Workbooks' button.
In the dialog box that opens (the UnsavedFiles folder), locate your lost file, select it, and click 'Open'. Once it opens in Excel, immediately go to 'File' > 'Save As' to secure the file.
Manually Locate the AutoRecover Folder
If Excel does not prompt you with recovery options, you can manually navigate to the AutoRecover directory on your PC.
Search for System Temporary Files
As a last resort, check the Windows temporary folder for backup files created before the crash.
Experience Stable Performance with WPS Office
Tired of unexpected software crashes leading to data loss? Switch to WPS Office, a free and lightweight alternative to Microsoft Office. It offers highly stable performance and robust auto-backup features to ensure your spreadsheets are always safe.
- 1. Download WPS Office: Visit the official WPS website to download and install the free office suite on your device.
- 2. Enable Smart Backup: Open WPS Spreadsheet, navigate to Menu > Settings > Backup Setting, and enable local smart backup.
- 3. Work Without Worries: Continue editing your Excel files natively in WPS Office, knowing your progress is safely backed up.
Frequently Asked Questions
Why didn't Excel save an AutoRecover version of my file?
Excel's AutoRecover only triggers if the file was open longer than the set AutoRecover interval (which defaults to 10 minutes) or if the feature was accidentally disabled in your Excel Save options.
Can I recover an unsaved Excel file if I accidentally clicked 'Don't Save'?
Yes. Excel often keeps a temporary copy of files closed without saving. You can access it by opening Excel and going to File > Info > Manage Workbook > Recover Unsaved Workbooks.
Where is the default AutoRecover location in Windows?
By default, Windows stores Excel AutoRecover files at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. The AppData folder is hidden by default, so you may need to enable 'Hidden items' in File Explorer's View tab.
Will a Windows System Restore bring back my unsaved Excel file?
No, Windows System Restore is designed to revert system files, drivers, and settings to an earlier state. It does not affect, back up, or recover personal documents like unsaved Excel files.
