Does Shared Workbook feature work when file is managed through SharePoint ?

[cherias]

Dear All,

From the web link : https://support.office.com/en-nz/ar...laborate-b8207fe9-a613-483f-b804-0ca4658b0c61 I have understood that the SHARED WORKBOOK feature in Excel, allows multiple user to read and write on a single EXCEL Workbook kept on a common NETWORK SHARE.

I am wondering if a WORKBOOK with SHARED WORKBOOK feature enabled, work well and as expected when loaded and managed through SHAREPOINT ? What can be the drawbacks ?

Thanks in advance.

 

[Gingertrees]

Sharepoint is the best setting for this sort of thing.
The major downside here is that so long as users have the right to download and upload, they are free and able to completely hose the workbook in question, delete important data out of it, eliminate or overwrite code, etc.

But, for what it's worth, it's not bad.

 

[blbat]

A tip: Always keep a "master copy" of your spreadsheet on your local hard drive...that way when the users mess up the copy on the SharePoint server, or Shared Drive, you can revert back to known good.

 

[cherias]

Thanks a lot GingerTress for your input. Though I haven't yet tried uploading and running the Excel User form through the Share Point, but will try and seek suggestion through this very helpful forum.

Thanks a Lot

 

[cherias]

Thanks blbat for the input, I will definitely keep a local backup copy of the excel, just in case anything goes wrong with the SharePoint copy.

Thanks a lot.