Fix Excel Legacy Sharing Inserting Rows Instead of Showing Conflict Prompts
Question details
The user needs to fix a shared workbook issue where conflicting edits bypass the resolution prompt and instead duplicate data by inserting rows.

- Product
- Excel (Microsoft 365 Apps)
- Device & OS
- Windows
- Scenario
- Multiple users are collaborating on an Excel workbook using the Share Workbook (Legacy) feature, and simultaneous edits are creating conflicts.
- Observed behavior
- Instead of displaying the "Ask me which changes win" dialog box during a conflict, Excel automatically inserts a new row and keeps both values. This unexpected behavior is isolated to one specific coworker's computer.
Verify whether the issue is isolated to a single computer by having another coworker test the shared workbook on their machine. Also, ensure you have the necessary administrative permissions on the affected Windows PC to run an Office application repair.
Verify Legacy Sharing Conflict Resolution Settings
Ensure that the workbook is properly configured to prompt the user when conflicting changes occur.
Even if the workbook works correctly on other computers, checking the workbook's internal sharing settings on the affected machine is the first step to ensuring the conflict dialog isn't overridden locally.
Open the affected workbook in Excel. Navigate to the 'Review' tab on the ribbon and click on 'Share Workbook (Legacy)'.
In the Share Workbook dialog box, click on the 'Advanced' tab.
Under the 'Conflicting changes between users' section, ensure the radio button for 'Ask me which changes win' is selected. Click 'OK' to save the settings and test the workbook again.

Update and Repair Microsoft 365 Apps
Run an update and online repair to fix localized application corruption or version discrepancies causing the conflict prompt to fail.
Try WPS Office for Seamless and Conflict-Free Spreadsheet Collaboration
Dealing with legacy sharing errors in Excel can disrupt teamwork and duplicate data. WPS Office offers a lightweight, highly compatible alternative with robust cloud collaboration features, allowing multiple users to co-author spreadsheets simultaneously without legacy synchronization bugs.
- 1. Download and Install WPS Office: Download WPS Office from the official website and complete the quick installation process.
- 2. Open Your Excel Workbook: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks without losing any formatting or data.
- 3. Collaborate in Real-Time: Click the 'Share' button in the top right corner to invite coworkers via a collaboration link, allowing simultaneous editing without the need for legacy conflict prompts.

Frequently Asked Questions
Why is Excel's 'Share Workbook' feature called 'Legacy'?
Microsoft introduced a newer, modern co-authoring feature for Microsoft 365 that relies on OneDrive and SharePoint. The older, file-based sharing method was renamed to 'Share Workbook (Legacy)' and is hidden by default in newer versions of Excel because it is prone to sync issues.
How do I add the Legacy Share Workbook button to my Excel ribbon?
Go to File > Options > Quick Access Toolbar. In the 'Choose commands from' drop-down, select 'All Commands'. Scroll down to find 'Share Workbook (Legacy)', select it, and click 'Add', then click 'OK'.
Can different Excel versions cause sharing conflict errors?
Yes. If coworkers are collaborating on a legacy shared workbook using different builds or versions of Excel, the sharing features might behave inconsistently. This can cause the conflict resolution prompt to fail or automatically duplicate rows on certain machines. Keeping all Office installations updated on the same release channel resolves most of these discrepancies.




