Publish Workbook To Sharepoint Site. On the Site Collection Features page next to SharePoint Server Publishing Infrastructure click Activate. In the dialog box enter the web address for the SharePoint site and then browse to the site or library in which you want to save your workbook.
Activate Publishing features at the site collection level. So I created a method in a module using the below code. Make sure you can browse to the SharePoint location using UNC path.
Make sure you can browse to the SharePoint location using UNC path.
In SharePoint Online select the More menu next to the workbook you want to share and click Share. Open a web browser. In the address line type the address to a library in SharePoint Server 2013. Activate Publishing features at the site collection level.