Fix Excel Shared Workbook Requiring Users to Save Copies
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.

- 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.
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.
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.
Log in to your OneDrive or SharePoint account via your web browser and upload the Excel file you wish to share.
Open Microsoft Excel on your desktop, navigate to File > Open, and select the file directly from your connected OneDrive or SharePoint location.
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.
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.

Manually Merge Conflicting Workbook Copies
If cloud sharing is strictly unavailable and users have already saved separate copies, you must manually consolidate the changes.
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. Install WPS Office: Download and install WPS Office for free from the official website.
- 2. Open your spreadsheet: Open your existing Excel (.xlsx) file directly in WPS Spreadsheets.
- 3. Share and collaborate: Click 'Share' to upload it to WPS Cloud and invite others to edit the document simultaneously in real-time.

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.




