I'm automating the creation of a report, the requirement is to create a workbook and save it on a network drive.
The users currently create a single workbook and make it shared so that they all can update it with optimistic concurrency. Now when creating that workbook from code, can I make it shared too just as they manually do?
This feature is not supported yet. We will implement it in the future release. Could you post your sample file here? Thank you.
Thanks for the update.
The workbook uses the network NT logins for the sharing thing so I am not sure if you will be able to see the effect of sharing but you can easily recreate the same thing on your local network by opening an excel file and going to Tool->Share Workbook and Tool->Share Workspace.