Version History Issues

Recover Lost Excel Changes After a OneDrive Sync Failure

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

The user needs to recover Excel workbook changes that were lost after a possible OneDrive sync failure and merge prompt.

Recover Lost Excel Changes After a OneDrive Sync Failure
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.
Before you start

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.

Solution 1Recommended

Check OneDrive Version History and Conflict Copies

Look for a cloud version or separate copy that contains the missing changes.

1
Check version history

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.

2
Search for copies

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.

3
Compare before restoring

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.

Unsynced changes may be absent: OneDrive version history cannot show changes that never reached OneDrive. If no local recovery or conflict copy exists, those changes may not be recoverable.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for existing workbooksSave separate workbook copies when reviewing conflicting changesWork with a free, lightweight office suite
microsoft office alternative - wps office

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.