Excel Performance Problems

Fix Excel Freezes When Inserting Rows in a Shared Workbook

Khadija Khan Sep 28, 2026 869 views

Question details

Users experience Excel freezing or crashing when attempting to insert or delete rows in a workbook that uses the legacy Share feature.

Fix Excel Freezes When Inserting Rows in a Shared Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Collaborating on a legacy shared workbook and modifying its structure.
Observed behavior: Excel stops responding or crashes entirely during row insertion or deletion in shared mode, but functions normally when unshared.

Before you start

Before troubleshooting, ask all users to save and close the file, then temporarily turn off legacy sharing and save a backup copy to your local drive to prevent data loss.

Solution 1Recommended

Transition to Modern Co-Authoring

Microsoft has replaced the legacy "Share Workbook" feature with modern Co-authoring, which resolves structural editing crashes and improves performance.

Legacy shared workbooks often struggle with structural changes like inserting or deleting rows, especially if multiple users are connected. Upgrading to modern co-authoring provides real-time collaboration without these freezing issues.

Disable legacy sharing

Open the affected workbook in Excel. Go to the 'Review' tab, click 'Share Workbook' (or 'Unshare Workbook' in newer versions), uncheck the option 'Allow changes by more than one user at the same time', and click OK.

Upload to cloud storage

Navigate to 'File' > 'Save As' and upload the workbook to your Microsoft OneDrive or SharePoint library.

Invite users to co-author

Click the 'Share' button in the top right corner of the Excel window, enter the email addresses of your team members, and click 'Send' to invite them to the modern co-authoring session.

Modern Co-authoring Benefits: Co-authoring allows multiple users to edit the file simultaneously in real-time, completely bypassing the structural conflicts that cause legacy shared workbooks to freeze.

Solution 2

Ensure All Users Have the Same Excel Build

Mismatched Excel versions or outdated builds among users can corrupt the legacy shared workbook and cause it to crash.

Free Microsoft Office alternative

Use WPS Office for Seamless Collaboration

Avoid legacy workbook sharing crashes with WPS Office. Enjoy a lightweight, fast, and secure document collaboration experience with excellent Microsoft Excel compatibility.

1. Download and install: Get the free WPS Office suite from the official website and install it on your device.
2. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx workbook directly with zero compatibility issues.
3. Collaborate securely: Use WPS Cloud features to share the document with your team for seamless co-editing without structural freezing.

Fully compatible with Microsoft Excel (.xlsx) formatsModern cloud-based collaboration without legacy sharing crashesLightweight application that runs smoothly on most devicesFree to download and use with a highly familiar interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel freeze only when the workbook is shared?

Legacy workbook sharing handles simultaneous data entry and structural changes differently than standard mode. When multiple users are connected, structural modifications like inserting or deleting rows can cause data conflicts, leading to application hangs or crashes.

How can I safely unshare a workbook without losing data?

Ensure all other users have saved their work and closed the file. Then, go to the Review tab, click 'Share Workbook', uncheck the option allowing changes by multiple users, and save the file. This converts it back to a standard, unshared workbook.

Is the legacy Share Workbook feature still supported?

Microsoft has hidden and deprecated the legacy 'Share Workbook' feature in newer Microsoft 365 versions due to performance and stability issues. It has been replaced by modern Co-authoring via OneDrive or SharePoint.

Can a corrupted Excel file affect other users sharing it?

Yes. If one user is running a buggy or outdated version of Excel, their actions can introduce corruption into the shared file, causing the workbook to freeze or crash for all other users accessing it.

Excel & Data Problems