How to Recover Unsaved Offline Edits in a Shared Excel Workbook
Question details
The user needs to recover changes made offline to a shared Excel workbook that conflict with newer cloud edits and are missing from version history.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Editing a shared Excel workbook offline while others update the cloud version.
- Observed behavior
- Offline edits conflict with the cloud version, fail to sync automatically, and do not appear in the cloud version history.
Ensure you are using the exact computer where the offline edits were made, as temporary files and local backups are stored locally on that specific device's hard drive.
Recover from Local Temporary or AutoRecover Files
Use this method to find local cached copies of your workbook created by Excel's AutoRecover feature during your offline session.
When offline edits fail to sync, the application may leave behind a temporary cache file or an AutoRecover version on your local storage before discarding the session.
Launch the Excel application, click on the 'File' tab in the top left corner, and select 'Open' from the sidebar menu.
Click on 'Recent' and scroll to the very bottom of the recent files list. Click the 'Recover Unsaved Workbooks' button.
A file explorer window will open pointing to the default UnsavedFiles directory. Look for any files ending in .tmp or .xlsb that match the date and time of your offline session.
Open the located file. If it contains your missing edits, immediately go to 'File' > 'Save As' and save it to your desktop with a new name.

Search for Local Sync Copies or Backups
If AutoRecover files are unavailable, search your computer for locally saved duplicates or utilize Windows file history.
Try WPS Office for Reliable File Backup and Editing
Tired of complicated sync conflicts and lost offline edits? WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office. With built-in local backup management and intuitive cloud collaboration, you can ensure your hard work is always protected, whether you are online or offline.
- 1. Download and Install: Download WPS Office for free from the official website and complete the quick installation process.
- 2. Open Your Spreadsheets: Open your existing Microsoft Excel (.xlsx) files directly in WPS Spreadsheet with all formatting and formulas preserved.
- 3. Enable Auto-Backup: Go to Settings > Backup Settings in WPS Office to enable local backup, ensuring all offline edits are safely stored on your device.

Frequently Asked Questions
Why didn't my offline edits sync to the shared workbook?
When multiple people edit a shared cloud document and you go offline, your local changes may conflict with new cloud updates made by others. If the application cannot automatically merge the conflicting data, your offline edits may be discarded or saved as a separate conflict file rather than syncing to the main document.
Can I find unsaved offline changes in the cloud version history?
No. Cloud version history only tracks changes that have successfully synced to the server. If your edits were made offline and failed to sync due to conflicts or network issues, they will not appear in the online version history.
Where does Excel store temporary AutoRecover files?
By default on Windows, AutoRecover files are stored locally in 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\'. You can navigate to this hidden directory using File Explorer to look for unsaved offline drafts.




