Forum Discussion
Shared Workbook function doesn't work in Terminal server Win2K19 with Excel 2019
Share Workbook (Legacy) is a 'use at your own risk' feature (Microsoft encourages people to use co-authoring). The issue with this feature is it does not work well with network shares. Quite often, network shares will keep the Excel file session open even when the file closes. This leads to the read-only notice and Excel saying you have the file open.
A network admin may connect to the server and clear the open sessions:
- kpr208Aug 04, 2022Copper Contributor
Thanks for your response Patrick2788.
Our issue different from File lock with Network shares which you mentioned.
In our case, Same Excel file allows multiple users to edit when it accessed from local machine which has O365 installed. But when the same excel file(Located in OneDrive) is accessed from Server(Win2k19 + Office 2019), Its not allowing multiple users to access it.
I believe the reason why it works well from local machine, User opens Excel and OneDrive in O365 platform with an O365 account. So synchronization is happening properly. But when it comes to Server, It fails.
Was it because of Excel 2019 to One Drive syncing won't work technically or something else I am missing here? is there a way to overcome this?