Forum Discussion

kpr208's avatar
kpr208
Copper Contributor
Aug 03, 2022

Shared Workbook function doesn't work in Terminal server Win2K19 with Excel 2019

We have Office 2019 installed in Windows servers(Win2k19). Users are accessing Excel files available in OneDrive(Available through local resources drive mapping). Excel file has shared workbook funct...
excel
Patrick2788's avatar
Patrick2788
Silver Contributor
Aug 03, 2022

kpr208 

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:

 

 

  • kpr208's avatar
    kpr208
    Copper Contributor
    Aug 04, 2022

    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?

Resources