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

cherias

New Member
Joined
Sep 9, 2015
Messages
15

Gingertrees

Well-known Member
Joined
Sep 21, 2009
Messages
697
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

Active Member
Joined
Mar 24, 2010
Messages
289
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

New Member
Joined
Sep 9, 2015
Messages
15
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

New Member
Joined
Sep 9, 2015
Messages
15
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.
 

Forum statistics

Threads
1,085,843
Messages
5,386,297
Members
401,992
Latest member
CleverHopper

Some videos you may like

This Week's Hot Topics

Top