File Sharing Problems

Share and Edit Excel Workbooks with Multiple Users

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 869 views

Question details

The user wants multiple people to edit an Excel workbook and understand the limitations of legacy shared workbooks on network drives.

Share and Edit Excel Workbooks with Multiple Users
Product
Microsoft Excel
Device & OS
not provided
Scenario
Multiple users need to collaborate on the same workbook, potentially from a shared network location.
Observed behavior
Legacy shared workbooks on network drives can remain locked after a user closes them, preventing others from editing.
Before you start

Check whether the workbook is stored on a network drive, OneDrive, or SharePoint, and confirm that collaborators have access to the intended location. For modern co-authoring, use a supported Excel version and an .xlsx workbook.

Solution 1Recommended

Co-author the workbook through OneDrive or SharePoint

Use modern co-authoring for more reliable simultaneous editing.

1
Save the workbook to the cloud

In Excel, select File > Save As and save the workbook as an .xlsx file in OneDrive or a SharePoint library.

2
Share editing access

Select Share, enter the collaborators' email addresses, and make sure the link or invitation allows editing.

3
Edit together

Ask each collaborator to open the shared link in Excel for the web or a supported desktop version of Excel. Turn on AutoSave in desktop Excel when available to keep changes synchronized.

Co-author the workbook through OneDrive or SharePoint
Check for legacy sharing: If the workbook uses the legacy Shared Workbook feature, turn it off before using modern co-authoring. Some workbook features or settings may also prevent co-authoring.
Free Microsoft Office alternative

Work with Shared Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Its Microsoft Office format compatibility helps you move existing workbooks into WPS, although it does not fix Excel's network file locks.

Work with Excel spreadsheets in a familiar interfaceOpen and edit Microsoft Excel formats, including .xlsx and .xlsUse WPS Cloud sharing options to distribute spreadsheetsMove existing Office files to a lightweight, easy-to-use suite
microsoft office alternative - wps office

Frequently Asked Questions

Where should I save an Excel workbook for simultaneous editing?

Save it to OneDrive or a SharePoint library using File > Save As, then select Share and give collaborators editing permission.

Why does Excel say a closed workbook is locked for editing?

A network server may retain a stale lock after a legacy shared workbook is closed. Ask all users to close the file, then have an administrator check the server's open files if the lock remains.

Where is the Share Workbook command in Excel?

The legacy command may not appear on the ribbon. Add Share Workbook (Legacy) through File > Options > Quick Access Toolbar, under All Commands.

Can I use legacy shared workbooks and modern co-authoring at the same time?

Turn off the legacy Shared Workbook feature before using modern co-authoring, then save the workbook to OneDrive or SharePoint and share it with editing permission.