Fixing “File was not uploaded because changes cannot be merged” in OneDrive.

The error “File was not uploaded because changes cannot be merged” appears in Microsoft Excel when your local edits directly conflict with modifications made by another user or another device. While modern Excel automatically handles most co-authoring changes, certain structural edits—such as column deletions, table restructurings, or macro updates—cannot be resolved automatically, stopping the upload to prevent data corruption.

Quick Fix

Click Save a Copy on the error banner to save your current work to a distinct local file. Once that backup is saved, click Discard Changes (or Reopen from Server) on the original file to download the current cloud version, then copy your unique edits from the local backup back into the live spreadsheet.

---

Step 1: Isolate and Protect Your Local Changes

When the merge engine stops, your local desktop client holds unsynchronized edits that do not exist on the server. If you simply close Excel or force-kill OneDrive, those unmerged changes will be overwritten.

1. Locate the red or yellow notification bar below the Excel ribbon stating: “Upload Failed: We couldn’t merge your changes.”
2. Click the Save a Copy button directly on that alert.
3. Save the document to your local hard drive (outside the OneDrive sync tree) with an appended name, such as Workbook_Manual_Merge.xlsx.
4. Close the original document window. When asked what to do with the unmerged changes, choose Discard Changes. This tells Excel to dump the local stalled state and download the clean server copy.

---

Step 2: Understand Why the Merge Failed

Excel’s cloud co-authoring engine can merge standard cell edits seamlessly. However, it will fail and trigger this warning if it encounters:

• Conflicting Structural Alterations: User A converted a range into an official Excel Table (Ctrl + T) while User B deleted rows within that same range.
• Sheet-Level Sorting: Large-scale sorting actions across hundreds of rows while another user is concurrently entering data in adjacent columns.
• VBA/Macro Modifications: Altering Visual Basic code within an .xlsm file while another user has an active session. Code cannot be co-authored.
• Overlapping Cell Formatting: Applying conflicting custom conditional formatting or data validation rules to the same range simultaneously.

If you suspect sync conflicts are tied to an unreliable network connection or a stalled background queue, review Troubleshooting “Slow Cloud Save” and “Pending Upload” loops..

---

Step 3: Clear Corrupted OneDrive File Collaboration Hooks

If you frequently encounter merge failures on workbooks where only one person is working, the problem is not a true conflict. Instead, the local OneDrive sync engine has desynchronized its cache from Excel.

1. Right-click the OneDrive cloud icon in the Windows taskbar and select Settings.
2. Go to the Sync and backup tab and select Advanced settings.
3. Locate File collaboration (or “Use Office applications to sync Office files that I open”).
4. Toggle this setting Off, wait 15 seconds, and toggle it back On.
5. This forces OneDrive and Excel to clear their shared communication pipe and rebuild the differential sync mapping.

If the file remains locked with a perpetual upload block icon in the Windows file explorer, follow the credential reset steps in How to fix “Upload Blocked” and “Sign in required” for OneDrive/SharePoint files..

---

Step 4: Reconcile and Re-Apply Your Changes

Now that the live cloud document is unblocked, re-apply your changes from the backup file created in Step 1.

1. Open the original cloud workbook directly from SharePoint or OneDrive. Confirm that the title bar reads AutoSave On and Saved.
2. Open your local backup file (Workbook_Manual_Merge.xlsx).
3. If only a few cells were changed, copy and paste the updated cells into the cloud version.
4. If large sections were overhauled, use Excel’s built-in View Side by Side feature (View > View Side by Side) to review changes and avoid overwriting work that your colleagues committed while your upload was paused.

For persistent co-authoring conflicts that continue to desynchronize team spreadsheets, read “Merge Conflict”: Resolving co-authoring errors in Excel Online..

---

Summary Checklist

• Use Save a Copy immediately to prevent losing your local uncommitted edits.
• Discard the stalled local state on the original workbook to pull down the latest cloud baseline.
• Understand that structural changes (tables, row deletions, VBA) cannot be automatically merged during co-authoring.
• Cycle the “File collaboration” setting in OneDrive to clear communication deadlocks between Excel and the sync engine.
• Re-apply edits cleanly into the live cloud document.