File Sharing Problems

How to Merge Offline and Online Excel Co-Authoring Changes

Maira MehtabMaira Mehtab Nov 3, 2026 870 views

Question details

Users experience conflicts and syncing issues when trying to merge offline workbook changes with simultaneous online edits in a shared Excel file.

How to Merge Offline and Online Excel Co-Authoring Changes
Product
Microsoft Excel
Device & OS
not provided
Scenario
Multiple users co-authoring a macro-enabled Excel workbook, where one user edits the file offline while others continue to edit the online copy.
Observed behavior
Excel fails to reliably merge the changes between the offline and online versions, often resulting in version conflicts, especially when AutoSave settings differ.
Before you start

Ensure you save a separate local copy of your offline workbook under a different name before attempting to connect and merge, preventing any accidental data loss during synchronization.

Solution 1Recommended

Manually Compare and Merge Workbook Copies

Since automatic merging often fails for macro-enabled offline/online edits, saving separate copies and manually comparing the differences is the safest and most reliable method.

Excel's co-authoring feature struggles to reconcile simultaneous offline and online edits, particularly in macro-enabled (.xlsm) workbooks. To avoid losing data, you must intervene manually.

1
Save a local copy

While still offline, use 'Save As' to save your current offline version under a new name on your local hard drive.

2
Open the online version

Connect your device to the internet and open the latest online version of the workbook from your shared cloud storage.

3
Compare the changes

Open both the local copy and the online version side-by-side to visually identify the data you added or modified while offline.

4
Manually update the online file

Copy your offline updates and paste them into the appropriate cells of the online version, then allow AutoSave to sync the final merged document.

Manually Compare and Merge Workbook Copies
Macro Limitations: Co-authoring features have limited support and reduced stability for macro-enabled workbooks (.xlsm), which frequently causes auto-syncing to fail or create conflicting copies.
Free Microsoft Office alternative

Experience Seamless Collaboration with WPS Office

Struggling with syncing conflicts and complicated co-authoring issues? WPS Office offers a highly compatible, lightweight, and free alternative to Microsoft Office. With built-in cloud support, you can edit, share, and collaborate without the frustration of persistent version conflicts.

  1. 1. Download and Install: Visit the official WPS Office website to download and install the free suite.
  2. 2. Open your files: Launch WPS Spreadsheets and open your existing Microsoft Excel formats (.xlsx, .xlsm) seamlessly.
  3. 3. Collaborate easily: Save your workbooks to WPS Cloud to easily share links and collaborate with your team.
Free and lightweight alternative to Microsoft Excel.High compatibility with Microsoft Office formats, including .xlsx and .xlsm.Integrated WPS Cloud for smooth and reliable file sharing.Familiar user interface ensuring a zero-learning-curve transition.
QA img-9

Frequently Asked Questions

Why does my Excel file create a conflicting copy when I edit offline?

When you edit an Excel file offline while others edit the online version, Excel cannot merge the simultaneous changes in real-time. Once you reconnect, it creates a conflicting copy to prevent overwriting someone else's work.

Can I use real-time co-authoring on macro-enabled (.xlsm) workbooks?

Yes, but it is generally less stable than standard (.xlsx) files. Conflicts frequently occur with macros, especially if users have different AutoSave settings or temporarily lose internet connectivity.

Is there a VBA script to automatically merge offline Excel changes?

While some advanced users write custom VBA scripts to merge specific data ranges, there is no universal VBA method to reliably merge complex offline and online changes due to the high risk of data loss or corruption.

How do I turn on AutoSave for shared workbooks?

Open the shared file directly from your cloud storage (like OneDrive or SharePoint) and toggle the 'AutoSave' switch located in the top-left corner of the Excel application window.