Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

sharing and editing excel file between users

Copper Contributor


We have a shared network drive which is located on a terminal server .

the users see the network as a network mapped drive.

in the network mapped drive we have some excel files.


We would like to know if it is possible so that 2 users will be able to work on the same file at the same time : on the excel file .

our office version is office professional plus  2021. 

in the attached picture you can see that is possible to share a workbook.


I can also see that in excel on the upper hand right corner there is a possibility to share..

but we want to on our local computer







2 Replies


Excel has removed Share Workbook from the ribbon. It can be added by customizing the Quick Access Toolbar:



This feature is not encouraged because Co-Authoring via OneDrive/SharePoint is more reliable.  The issue with using the legacy feature is the fact that networks tend to keep the workbook locked even when it's been closed.  Inevitably, someone will get an error saying the workbook is locked for editing by [insert name of person opening workbook].