File Sharing Problems

Fix Excel Shared Workbook Requiring Users to Save Copies

John WilsonJohn Wilson Nov 2, 2026 868 views

Question details

Users attempting to collaborate on a legacy shared Excel workbook are forced to save separate copies instead of seamlessly updating the original file.

How to Fix Excel Shared Workbook Requiring Users to Save Copies
Product
Microsoft Excel
Device & OS
not provided
Scenario
Multiple users are trying to edit the same shared Excel workbook simultaneously without using modern cloud services like OneDrive.
Observed behavior
Excel blocks simultaneous edits and prompts users to save a copy of the workbook, leading to multiple conflicting file versions.
Before you start

Ensure you have a stable internet connection and access to a modern cloud storage service like OneDrive or SharePoint, as the legacy Shared Workbooks feature is deprecated and heavily limited.

Solution 1Recommended

Upgrade to Modern Co-authoring via OneDrive or SharePoint

The most reliable way to edit simultaneously is to use Microsoft's modern co-authoring feature, which replaces the unreliable legacy Shared Workbook function.

Microsoft has replaced the legacy 'Shared Workbook' feature with real-time co-authoring. To avoid version conflicts and 'save a copy' prompts, the file must be hosted in a supported Microsoft cloud environment.

1
Upload the file to the cloud

Log in to your OneDrive or SharePoint account via your web browser and upload the Excel file you wish to share.

2
Open the file from the cloud

Open Microsoft Excel on your desktop, navigate to File > Open, and select the file directly from your connected OneDrive or SharePoint location.

3
Invite collaborators

Click the 'Share' button in the top right corner of the Excel window. Enter the email addresses of your team members or copy a sharing link to send to them.

4
Ensure AutoSave is on

Verify that the 'AutoSave' toggle in the top-left corner of the Excel window is turned on. This ensures all users' edits are merged in real-time.

Upgrade to Modern Co-authoring via OneDrive or SharePoint
Real-time Collaboration: When collaborators open the link, you will see their profile icons in the top right corner, and their active cells will be highlighted with different colors.
Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

Stop dealing with conflicting file copies and legacy sharing limitations. WPS Office provides built-in cloud collaboration, allowing multiple users to edit the same spreadsheet simultaneously without the hassle.

  1. 1. Install WPS Office: Download and install WPS Office for free from the official website.
  2. 2. Open your spreadsheet: Open your existing Excel (.xlsx) file directly in WPS Spreadsheets.
  3. 3. Share and collaborate: Click 'Share' to upload it to WPS Cloud and invite others to edit the document simultaneously in real-time.
Free, lightweight, and incredibly easy to installFully compatible with Microsoft Excel formats (.xlsx, .xls)Real-time co-authoring via WPS Cloud without version conflictsFamiliar user interface that requires zero retraining
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep saving a copy instead of updating the shared file?

This usually happens when users are editing a legacy shared workbook without a supported cloud location (like OneDrive), or if multiple users try to save conflicting changes at the exact same time on an offline network drive.

Can I still use the legacy Shared Workbook feature in newer Excel versions?

Yes, but Microsoft has hidden it by default. You can restore it by adding 'Share Workbook (Legacy)' to your Quick Access Toolbar via File > Options. However, Microsoft strongly recommends using modern co-authoring instead to prevent data loss.

Does modern co-authoring require a Microsoft 365 subscription?

Yes, fully functional real-time co-authoring in the desktop Excel application requires an active Microsoft 365 subscription, and the file must be stored in OneDrive or SharePoint.

How do I know if someone else is currently editing the workbook?

If you are using modern co-authoring on a supported cloud platform, you will see your collaborators' initials or profile pictures in the top-right corner of the Excel window, and their currently active cell will be highlighted with a colored border.