Forum Discussion
orrtech
Jan 25, 2023Copper Contributor
sharing and editing excel file between users
Hi 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 li...
Patrick2788
Jan 25, 2023Silver Contributor
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].