How to Recover Excel Changes After a Merge Conflict
Question details
The user needs to recover lost edits in an Excel file after a co-authoring or synchronization merge conflict was accepted.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Multiple users are co-authoring a shared workbook or a user is syncing files via OneDrive, and a synchronization conflict occurs.
- Observed behavior
- One user's changes are overwritten, replaced, or completely lost after resolving or accepting a file merge conflict.
Stop making new changes to the affected workbook immediately and do not close the file if it is still open, to prevent overwriting your temporary cache or version history.
Compare Local Copies with the OneDrive Web Version
Check if your local unsynced copy still retains your work before it gets fully overwritten by the cloud version.
Merge conflicts often happen due to network interruptions between your local Excel app and the cloud file. If you haven't closed your local file yet, your edits might still be safely stored on your hard drive.
Click 'File' > 'Save As' and choose a local folder on your computer (like the Desktop) to save the current state of your workbook under a new name.
Log in to OneDrive for the web in your browser, locate the original shared Excel file, and open it to view the server's version.
Open both the local copy and the web version side-by-side. Copy the missing changes from your local file and paste them into the web version, then ensure it saves properly.

Restore a Previous Version via OneDrive
Roll back the Excel file to a timestamp recorded right before the merge conflict occurred.
Contact Microsoft Support or Your Administrator
Reach out to your IT department or Microsoft Support if local copies and version history fail to restore the lost data.
Try WPS Office for Seamless Collaboration and File Sync
Tired of complicated merge conflicts and lost data? WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office. With WPS Cloud, you can enjoy stable co-authoring, automatic backups, and an easy-to-use version history feature to keep your team's work perfectly synced and safe.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open Your Excel Files: Double-click your existing .xlsx files to open them directly in WPS Spreadsheet without losing any formatting.
- 3. Enable WPS Cloud Sync: Sign in to your WPS account and save your files to WPS Cloud to enjoy real-time auto-saving and seamless team collaboration.

Frequently Asked Questions
Why do Excel merge conflicts happen during co-authoring?
Merge conflicts usually occur when multiple users attempt to edit the exact same cell simultaneously, or when offline changes sync back to the cloud and contradict another user's edits made during the offline period.
Can I recover unsaved changes if I closed the Excel file after a conflict?
If AutoSave was enabled, you can check the 'Unsaved Files' folder by navigating to File > Info > Manage Workbook > Recover Unsaved Workbooks. If the file isn't there and not in OneDrive's version history, the changes are likely permanently lost.
How can I prevent merge conflicts in shared workbooks in the future?
Ensure you have a stable internet connection while co-authoring, communicate with your team to avoid editing the same data ranges at the same time, and verify that the AutoSave toggle is turned on in the top left corner of the Excel window.




