'%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 Unsaved Excel Files After a Computer Restart
Question details
The user needs to recover unsaved changes in a Microsoft Excel workbook after the computer unexpectedly reboots.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A computer restart occurs abruptly while a user is actively working on an Excel spreadsheet, causing the application to close before changes are manually saved.
- Observed behavior
- The Excel application is closed forcefully, and upon restarting the computer, the user cannot immediately find the unsaved modifications they were working on.
Ensure your computer has fully restarted and stabilized, and verify your internet connection if your files were stored on a cloud-syncing service like OneDrive or SharePoint.
Use the Document Recovery Pane
This is the most direct and common method to retrieve unsaved work, as Excel automatically attempts to present auto-saved drafts after an unexpected crash or reboot.
Microsoft Excel features an automatic recovery mechanism that triggers when the application shuts down improperly. When you reopen the application, it will scan for temporary AutoRecover files.
Close any blank Excel windows that might have opened upon startup. Open the Microsoft Excel application directly from your Start menu or desktop shortcut without opening a specific workbook file.
Look at the left side of the Excel interface. If Excel successfully salvaged your work, a 'Document Recovery' pane will appear displaying available recovered files with timestamps.
Click on the most recent version of your workbook in the Document Recovery pane to open it. Once verified, immediately click File > Save As and save it with a new file name to prevent data loss.
Manually Recover Unsaved Workbooks
Use this method if the Document Recovery pane fails to appear automatically when you launch Excel.
Restore from Cloud Version History
If you were working on a file saved to OneDrive or SharePoint, you can use Version History to recover the latest synced changes prior to the computer restarting.
Prevent Data Loss with WPS Office's Built-in Auto-Backup
If you struggle with lost work in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and completely free alternative with a robust Backup Center. The intelligent auto-backup feature continuously saves your progress in the background, ensuring your spreadsheets are always protected against unexpected power loss or computer restarts.
- 1. Download the Software: Visit the official WPS Office website and download the free installer for your Windows, Mac, or Linux computer.
- 2. Configure Backup Settings: Open WPS Spreadsheet, go to Menu > Settings > Backup Settings, and set your Auto-Backup interval to as low as 1 minute for maximum protection.
- 3. Edit Your Excel Files: Double-click your existing .xlsx spreadsheets to open them directly in WPS Office with full formatting retained.
Frequently Asked Questions
Where are Excel AutoRecover files saved on my computer?
By default in Windows, Excel AutoRecover files are stored in a hidden AppData folder. The typical path is C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can verify or change this specific location by opening Excel and navigating to File > Options > Save.
Why didn't the Document Recovery pane appear after I restarted Excel?
The Document Recovery pane only triggers if Excel detected an abnormal shutdown and had successfully saved an AutoRecover file beforehand. If AutoRecover was disabled, the time elapsed since the last manual save was less than your AutoRecover interval (default is 10 minutes), or the file was heavily corrupted, the pane will not appear.
Can I recover an unsaved Excel file if I accidentally clicked 'Don't Save'?
Yes, it is often possible. Excel has a feature called 'Keep the last AutoRecovered version if I close without saving'. To access these files, go to File > Info > Manage Workbook > Recover Unsaved Workbooks and look for your file in the directory that opens.
How do I change how often Excel auto-saves my work?
To minimize data loss in the future, you can shorten the AutoRecover interval. Go to File > Options > Save. Locate the setting 'Save AutoRecover information every X minutes', change the value to your preferred time (e.g., 1 or 2 minutes), and click OK.
