File Sharing Problems

Fix Excel Shared Workbook Not Saving and Creating a Copy

Algirdas Jasaitis Oct 13, 2026 871 views

Question details

A shared Excel workbook fails to save edits directly to the original file and instead generates a separate workbook copy containing the new changes.

Fix Excel Shared Workbook Not Saving and Creating a Copy

Product: Microsoft Excel
Device & OS: not provided
Scenario: Multiple users are collaborating on a shared workbook that includes both protected and editable areas.
Observed behavior: After users edit several cells, the file intermittently stops saving. Excel then automatically creates and saves a separate workbook copy that contains the latest edits instead of updating the shared file.

Before you start

Make sure to temporarily save the newly created copy to a safe local folder so you do not lose any of your recent data entries before troubleshooting the sync issue.

Solution 1Recommended

Open Directly in the Excel Desktop Application

Opening the workbook directly from within Excel bypasses potential conflicts and caching issues caused by the local OneDrive sync client.

The OneDrive desktop sync client can sometimes struggle to merge co-authoring changes, especially in workbooks with protected areas. Accessing the file straight from the cloud server via the Excel application usually resolves this file-locking behavior.

Launch Excel

Open the Microsoft Excel desktop application instead of double-clicking the workbook from your local Windows File Explorer or Mac Finder.

Access Open Menu

Click on 'File' in the top-left corner of the Excel window, then select 'Open' from the left-hand sidebar.

Select Cloud Location

Choose 'OneDrive' or 'SharePoint' from your connected services, browse to the location of the shared workbook, and open it directly from the cloud.

Open Directly in the Excel Desktop Application

Check Sync Status: If the file saves correctly using this method, the issue is likely rooted in your local OneDrive sync app. You may need to pause and resume syncing or reset OneDrive.

Solution 2

Update Excel for All Collaborators

Co-authoring issues frequently occur when users editing the shared file are on mismatched or outdated versions of Excel.

Solution 3

Isolate File-Specific Corruption

Testing a brand-new workbook helps determine whether the problem is specific to the original file's formatting and protected areas or a broader network issue.

Free Microsoft Office alternative

Experience Seamless Co-authoring with WPS Office

If Excel's shared workbooks keep creating conflicting duplicate copies, consider switching to WPS Office. It provides a highly compatible, stable, and built-in cloud environment for real-time spreadsheet collaboration without the sync errors.

1. Install WPS Office: Download and install the free WPS Office suite on your desktop or mobile device.
2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx workbook directly—no formatting will be lost.
3. Collaborate in Real-Time: Upload the file to WPS Cloud and invite your team to edit simultaneously without the fear of creating duplicate conflicting copies.

100% format compatibility with Microsoft Excel (.xlsx, .xls, .csv)Real-time co-authoring via WPS Cloud without generating duplicate offline copiesFree to download and use with a highly familiar user interfaceLightweight application that runs smoothly and opens large data files rapidly

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel automatically create a copy of my shared workbook?

Excel creates a copy when it detects a synchronization conflict, a file lock by another user, or when the local OneDrive cache is struggling to communicate with the server. Instead of overwriting and potentially deleting someone else's data, Excel safely saves your recent edits into a new, separate file.

Can workbook protection cause shared Excel files to stop saving?

Yes. Certain legacy workbook protection features or unsupported elements (like specific macros or complex data validation) can prevent real-time co-authoring from functioning correctly. This causes the file to lock, forcing Excel to save a copy for any new edits made.

How do I merge the changes from the copied workbook back into the original?

You must manually copy the updated cells from the newly generated copy and paste them back into the original shared workbook. To prevent further sync conflicts, ensure that no other collaborators are actively editing the original file while you merge your changes.

Document & File Issues