sharing and editing excel file between users

Question

HiWe 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.&nbsp;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&nbsp; 2021.&nbsp;in the attached picture you can see that is possible to share a workbook.&nbsp;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&nbsp;thank&nbsp;Omer&nbsp;&nbsp;

wassimn · Answer

Hello orrtechLook at this and see if it helps:https://contexturesblog.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/

patrick2788 · Answer

orrtech&nbsp;Excel has removed Share Workbook from the ribbon. It can be added by customizing the Quick Access Toolbar:&nbsp;This feature is not encouraged because Co-Authoring via OneDrive/SharePoint is more reliable.&nbsp; The issue with using the legacy feature is the fact that networks tend to keep the workbook locked even when it's been closed.&nbsp; Inevitably, someone will get an error saying the workbook is locked for editing by [insert name of person opening workbook].

Forum Discussion

sharing and editing excel file between users

Share

Resources