'%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 Excel File That Closed Unexpectedly
Question details
The user needs to recover an Excel spreadsheet that closed unexpectedly without saving, leaving the file inaccessible or missing the latest edits.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The Excel application closed unexpectedly due to a crash, power outage, or accidental closure before saving.
- Observed behavior
- The Excel file is no longer accessible, unsaved, or missing recent changes after an unexpected application closure.
Before attempting recovery, ensure your device has a stable power supply and do not restart your computer immediately, as this might clear temporary files needed for recovery.
Use Excel's Built-in 'Recover Unsaved Workbooks' Feature
This is the most direct method to restore files that closed unexpectedly without being saved.
Launch Microsoft Excel and create a new blank workbook to access the main interface.
Click on the 'File' tab in the top-left corner and select 'Info' from the left-hand menu pane.
Click on the 'Manage Workbook' icon and choose 'Recover Unsaved Workbooks' from the drop-down menu.
In the dialog box that appears, look for your unexpectedly closed file, select it, and click 'Open'. Be sure to save it immediately to a secure location.
Restore from OneDrive Backups and Version History
Use this method if your Excel file was synced to OneDrive or if you were using Excel for the web.
Check System Temporary Files and File History
If Excel's built-in tools and OneDrive fail, Windows may have kept a temporary copy or a File History backup.
Prevent Data Loss with WPS Office Auto-Backup
WPS Office features robust local and cloud auto-backup systems to ensure you never lose your progress if a spreadsheet closes unexpectedly. You can easily recover unsaved files through its intuitive backup management center.
- 1. Open Backup Management: Open WPS Spreadsheets, click on 'Menu' at the top left, hover over 'Backup and Recovery', and select 'Backup Center'.
- 2. Navigate to Local Backups: In the Backup Center, click on 'Local Backup' to view a list of all automatically saved temporary files.
- 3. Restore Your File: Find your recently closed file by checking the modified dates, double-click to open it, and save the recovered spreadsheet to your desired folder.
Frequently Asked Questions
Where are Excel temporary files stored on Windows?
By default, Excel temporary files are stored in C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles. You can navigate to this path using Windows File Explorer, but you may need to enable 'Show hidden files' in your folder options first.
How often does Excel AutoRecover save my files?
Excel AutoRecover saves your files every 10 minutes by default. You can change this interval by going to File > Options > Save and adjusting the 'Save AutoRecover information every' setting to a shorter time limit.
Can I recover an Excel file if I clicked 'Don't Save'?
Yes, if AutoRecover is enabled and the file was open long enough for an auto-save to trigger. Open Excel, go to File > Info > Manage Workbook > Recover Unsaved Workbooks, and check if a draft of the file is available.
Does third-party data recovery software work for Excel files?
Yes, reputable data recovery tools can often retrieve deleted or lost Excel files by scanning your hard drive for residual file fragments, provided that the data hasn't been overwritten by new files.
