OneDrive File Issues

How to Fix OneDrive Open in Office to Merge Changes Not Working

Maira Mehtab Sep 27, 2026 869 views

Question details

The user is unable to resolve a file conflict in OneDrive because the built-in merge function fails to execute properly in Excel.

Product: OneDrive and Microsoft Excel
Device & OS: not provided
Scenario: Attempting to sync an Excel file in OneDrive after a conflict is detected, using the prompt to merge changes.
Observed behavior: Selecting 'Resolve' and then 'Open in Office to Merge Changes' produces no result. Excel simply reopens the existing version, and the OneDrive status icon continues to display a red X.

Before you start

Before attempting any sync troubleshooting, immediately copy the problematic file and save it with a new name to ensure your latest un-synced edits are safely preserved.

Solution 1Recommended

Manually Review Version History and Combine Edits

When the automatic merge tool fails, bypass the error by manually saving a copy and pulling the previous version from OneDrive online.

File conflicts usually occur when a document is open on multiple devices or edited simultaneously by different users without AutoSave functioning properly. If the automatic merge fails, manual intervention via version history is the safest route.

Save a Local Copy

Open the conflicted file on your computer, click 'File' > 'Save As', and save a copy to your Desktop with a different name (e.g., 'Document_Manual_Backup.xlsx').

Access OneDrive Version History

Compare and Restore

Download the last successfully synced version from the web interface. Open both files side-by-side to manually copy over any missing data to your new backup file, then upload it to replace the broken one.

Account Type Verification: Check whether you are using a personal or business OneDrive account, as business accounts may have stricter IT policies restricting certain merge features.

Solution 2

Pause and Restart OneDrive Sync

Refreshing the OneDrive sync application can clear temporary glitches preventing the merge prompt from triggering Excel properly.

Free Microsoft Office alternative

Avoid Sync Conflicts with WPS Office

If you frequently encounter frustrating file conflicts, broken merge prompts, and sync errors in Microsoft Office, try switching to WPS Office. It provides a lightweight, highly compatible alternative with smooth built-in cloud synchronization to keep your files updated across all devices safely.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Existing Spreadsheets: Launch WPS Spreadsheets and seamlessly open your .xlsx files; all your formulas and formatting will remain perfectly intact.
3. Enable WPS Cloud Sync: Log in to your WPS account to turn on Auto-Backup and Cloud Sync, eliminating the risk of multi-device merge errors.

Free and lightweight office suite with a fast installation processHighly compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formatsBuilt-in WPS Cloud for seamless, reliable cross-device syncingFamiliar tabbed user interface with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file have a red X on the OneDrive icon?

A red X indicates a sync error. This usually happens when OneDrive detects a file conflict (multiple people editing simultaneously or edits made on offline devices) or when the file is locked by another background application.

Does the 'Open in Office to Merge Changes' feature work for all file types?

No, this specific feature is exclusively designed for Microsoft Office documents like Word, Excel, and PowerPoint. If the file is heavily corrupted, locked by another user, or not supported by your current Office version, the merge prompt will fail to execute.

How can I prevent OneDrive file conflicts in the future?

To minimize file conflicts, always ensure the AutoSave toggle is turned on when collaborating. Additionally, avoid leaving documents open on idle computers, keep your Office apps updated, and maintain a stable internet connection while working.

Document & File Issues