Share and Edit Excel Workbooks with Multiple Users
Question details
The user wants multiple people to edit an Excel workbook and understand the limitations of legacy shared workbooks on network drives.

- 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.
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.
Co-author the workbook through OneDrive or SharePoint
Use modern co-authoring for more reliable simultaneous editing.
In Excel, select File > Save As and save the workbook as an .xlsx file in OneDrive or a SharePoint library.
Select Share, enter the collaborators' email addresses, and make sure the link or invitation allows editing.
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.

Add the legacy Share Workbook command to Excel
Use this option only when an existing workflow requires the legacy Shared Workbook feature.
Resolve a workbook lock on a network drive
Use these checks when Excel says a legacy workbook is locked after someone has closed it.
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.

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.




