How to Merge Offline and Online Excel Co-Authoring Changes
Question details
Users experience conflicts and syncing issues when trying to merge offline workbook changes with simultaneous online edits in a shared Excel file.

- 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.
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.
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.
While still offline, use 'Save As' to save your current offline version under a new name on your local hard drive.
Connect your device to the internet and open the latest online version of the workbook from your shared cloud storage.
Open both the local copy and the online version side-by-side to visually identify the data you added or modified while offline.
Copy your offline updates and paste them into the appropriate cells of the online version, then allow AutoSave to sync the final merged document.

Standardize AutoSave Settings and Online Collaboration
Prevent future conflicts by ensuring all co-authors maintain consistent settings and remain online during editing sessions.
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. Download and Install: Visit the official WPS Office website to download and install the free suite.
- 2. Open your files: Launch WPS Spreadsheets and open your existing Microsoft Excel formats (.xlsx, .xlsm) seamlessly.
- 3. Collaborate easily: Save your workbooks to WPS Cloud to easily share links and collaborate with your team.

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.




