Fix Excel Changes Not Saved Despite AutoSave Enabled
Question details
Users need to recover missing changes in an Excel or Microsoft 365 file that were not saved, even though the AutoSave feature reported a successful save.

- Product
- Excel and Microsoft 365
- Device & OS
- not provided
- Scenario
- Reopening or uploading an Excel file after making extensive edits with AutoSave turned on.
- Observed behavior
- Recent file edits are missing completely, despite AutoSave indicating that the changes were successfully saved to the cloud.
Ensure you have a stable internet connection and are logged into the correct Microsoft account, as AutoSave relies on cloud synchronization to update Version History on OneDrive or SharePoint.
Check Version History and Contact Microsoft Support
Use the Version History tool to verify if your latest edits reached the server, and escalate the issue to Microsoft Support if the changes are missing.
Sometimes, AutoSave may report a successful save locally, but a temporary server-side issue or sync delay prevents the data from successfully reaching Microsoft's backend.
If checking the Version History confirms that the latest sync is more than a week old or missing your recent edits, the data may require backend investigation to recover.
Open your file in Excel or Microsoft 365 Online. Click on the file name at the top of the application window and select 'Version History' from the dropdown menu.
Review the right-hand pane displaying previous versions. Look for a timestamp that corresponds to the time you were making the lost changes.
If you find a version containing your missing work, click the 'Restore' button under that specific version to overwrite the current file, or 'Save a Copy' to keep both.
If the latest version is old and no newer copy exists, contact Microsoft 365 Online Support. If you are on an organizational account, ask your IT Administrator to open a backend investigation ticket to recover the lost data.

Avoid Cloud Sync Issues with WPS Office
If you are frustrated by unreliable cloud saves and lost changes in Microsoft 365, consider switching to WPS Office. It provides a lightweight, highly compatible, and reliable offline and online document experience with robust local backup features.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files directly without any formatting loss.
- 3. Enable Local Backup: Go to Menu > Settings > Backup Settings to enable local auto-backup, ensuring your work is saved safely on your hard drive.

Frequently Asked Questions
Why did Excel AutoSave say it saved when it didn't?
This usually happens due to a temporary network interruption or a server-side issue with OneDrive/SharePoint. Excel's local cache may assume the upload was successful before the server fully processes and confirms the synchronized changes.
Where are temporary unsaved Excel files stored on my computer?
On a Windows PC, temporary or recovered Excel files are typically located in the folder: C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles. You can check this directory to see if a local cache of your work survived.
Can my IT administrator recover files that I cannot see in Version History?
Yes, Microsoft 365 administrators have access to deeper diagnostic tools and logs. They can raise specialized support tickets directly with Microsoft's backend engineering team to attempt server-side recovery of missing data.




