'%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 Lost Excel Work When AutoSave Was Enabled
Question details
The user needs to recover missing spreadsheet content that was lost despite having the AutoSave feature enabled.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to retrieve spreadsheet data that went missing after an editing session, assuming the cloud auto-save feature had captured the changes.
- Observed behavior
- The data previously entered is missing from the file upon reopening, and AutoSave did not seemingly capture or restore the latest changes.
Verify whether your original workbook was saved locally on your hard drive or uploaded to a cloud service like OneDrive or SharePoint, as AutoSave behaviors and recovery methods differ based on the storage location.
Restore from OneDrive or SharePoint Version History
Since the real-time AutoSave feature requires files to be stored in OneDrive or SharePoint, checking the cloud version history is the most reliable way to recover your work.
Microsoft 365's AutoSave continuously uploads changes to the cloud. If local sync failed or the file was overwritten, previous states of the document are kept in Version History.
Open your web browser and log in to your OneDrive or SharePoint account where the file is stored.
Navigate to the folder containing your target Excel file, right-click the file, and select 'Version history'.
Browse the list of previous versions by date and time. Select 'Restore' on the version that contains your missing work.
Use the Recover Unsaved Workbooks Option in Excel
If the file was not properly synced to the cloud, Excel might have retained a temporary local copy.
Search the Local UnsavedFiles Directory
Manually navigating to the local Microsoft Office unsaved files directory can sometimes reveal temporary backups if the built-in recovery menu is empty.
Avoid Data Loss with WPS Office's Reliable Auto-Backup
Experiencing sync and recovery issues with Microsoft 365? WPS Office offers a robust, built-in Auto-Backup feature that saves your files locally and to the cloud, ensuring your work is never lost. Enjoy a free, lightweight, and highly compatible alternative to Microsoft Office.
Frequently Asked Questions
Why didn't AutoSave work even though the toggle was on?
AutoSave in Microsoft 365 only functions correctly when the file is saved to OneDrive, OneDrive for Business, or SharePoint Online. If the file is saved locally on your hard drive, AutoSave is disabled, although the separate AutoRecover feature might still run periodically.
What is the difference between AutoSave and AutoRecover in Excel?
AutoSave continuously saves changes to files stored in the cloud (OneDrive/SharePoint) in real-time. AutoRecover saves a temporary backup of local files at set intervals (e.g., every 10 minutes) to help you recover work in case of an unexpected crash.
Can I recover an Excel file if I closed it without saving?
Yes, Excel often keeps a temporary draft. Go to File > Open > Recent and click on 'Recover Unsaved Workbooks' at the bottom of the list to check for unsaved drafts.
How can I prevent losing my Excel work in the future?
Always ensure your files are saved to a reliable cloud service to enable real-time AutoSave. For local files, go to File > Options > Save, and check 'Save AutoRecover information every X minutes' as well as 'Keep the last AutoRecovered version if I close without saving'.
