File Sharing Problems

Fix Excel Legacy Sharing Inserting Rows Instead of Showing Conflict Prompts

Rana GarciaRana Garcia Nov 2, 2026 869 views

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.

How to Fix Excel Legacy Sharing Inserting Rows Instead of Showing Conflict Prompts
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.
Before you start

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.

Solution 1Recommended

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.

1
Access Legacy Sharing Options

Open the affected workbook in Excel. Navigate to the 'Review' tab on the ribbon and click on 'Share Workbook (Legacy)'.

2
Check Advanced Conflict Settings

In the Share Workbook dialog box, click on the 'Advanced' tab.

3
Enable the Conflict Prompt

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.

Verify Legacy Sharing Conflict Resolution Settings
Legacy Features in Microsoft 365: If you do not see the 'Share Workbook (Legacy)' button, you may need to add it manually via File > Options > Quick Access Toolbar by selecting 'All Commands'.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Download WPS Office from the official website and complete the quick installation process.
  2. 2. Open Your Excel Workbook: Launch WPS Spreadsheet and seamlessly open your existing .xlsx workbooks without losing any formatting or data.
  3. 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.
Completely free and lightweight alternative to Microsoft OfficeHigh format compatibility with Microsoft Excel (.xlsx, .xls) filesModern real-time co-authoring without legacy sharing conflictsFamiliar user interface for immediate productivity and easy migration
microsoft office alternative - wps office

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.