Recover Lost Excel Changes After a OneDrive Sync Failure
Question details
The user needs to recover Excel workbook changes that were lost after a possible OneDrive sync failure and merge prompt.

- Product
- Microsoft Excel and OneDrive
- Device & OS
- Windows
- Scenario
- A workbook was edited with AutoSave enabled, but the computer may have shut down before OneDrive finished syncing. Excel later prompted the user to merge changes and save a copy.
- Observed behavior
- The day's changes are missing, and they do not appear in OneDrive version history. Windows previous versions are also unavailable.
Confirm that you are checking the correct workbook and OneDrive account, especially if multiple copies have similar names. Keep any conflict or recovery copies separate until you have compared their contents.
Check OneDrive Version History and Conflict Copies
Look for a cloud version or separate copy that contains the missing changes.
Sign in to OneDrive on the web, find the workbook, and right-click it or select the three-dot menu. Choose Version history and open any available versions to check their contents.
Use the OneDrive search box and File Explorer search to look for the workbook name, including similarly named or conflict copies created around the time of the merge prompt.
Open any promising version or copy in Excel and compare it with the current workbook. In OneDrive Version history, use Restore only after identifying the version you need.
Look for Excel AutoRecover and Unsaved Workbook Files
Check Excel's recovery options for a local copy that may contain edits missing from OneDrive.
Check Windows Previous Versions
Use this option if File History or another Windows previous-version source was enabled for the workbook.
Work With Excel-Compatible Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easy to move existing files into a different workflow. It cannot restore Excel changes that were never synced or retained in a recovery copy.

Frequently Asked Questions
Can I reopen Excel's Merge Changes prompt?
There is no reliable way to reopen the same prompt after it has been dismissed. Search OneDrive and File Explorer for the workbook name and any separate or conflict copy created during the merge.
Why are my edits missing from OneDrive version history?
If the computer shut down before the edits reached OneDrive, they may never have become a cloud version. Check Excel recovery files and local copies as well as OneDrive Version history.
Where can I find Excel's AutoRecover folder?
In Excel, go to File > Options > Save and look for the AutoRecover file location. Open that folder in File Explorer and inspect any relevant recovery files.
How can I reduce the chance of losing changes again?
Before shutting down, check the OneDrive sync status and wait for syncing to complete. If a conflict occurs, save a separate copy before merging changes so you can compare the files.




