Good day,

New to Sharepoint and looking for some insight…

I have a macro enabled workbook saved on a SharePoint site that will be available to multiple users. So far it seems that macros won’t work in the Excel web version which is good, but I also want to ensure that multiple people cannot open the file, edit it and save it simultaneously. I need to ensure that the file is only edited in the Desktop version of Excel. I have found “Check in” & Check out” under versioning but it seems to me that if someone forgets to check the file back in it will be come a huge issue. 

I am ok if the file opens as Read Only for all users except the first user that is editing the file and did try it but there was no warning that another user was on the file. When I tried to save it, I was told it was a Read Only file but there was no initial warning. It seems like what I am asking may already be functioning but I don’t want a subsequent user working on the file for an hour only to be told it was Read Only and they can’t save their work. 

Hope what I am asking/raising makes sense and would appreciate some guidance. 

Thanks

​Good day, New to Sharepoint and looking for some insight… I have a macro enabled workbook saved on a SharePoint site that will be available to multiple users. So far it seems that macros won’t work in the Excel web version which is good, but I also want to ensure that multiple people cannot open the file, edit it and save it simultaneously. I need to ensure that the file is only edited in the Desktop version of Excel. I have found “Check in” & Check out” under versioning but it seems to me that if someone forgets to check the file back in it will be come a huge issue.  I am ok if the file opens as Read Only for all users except the first user that is editing the file and did try it but there was no warning that another user was on the file. When I tried to save it, I was told it was a Read Only file but there was no initial warning. It seems like what I am asking may already be functioning but I don’t want a subsequent user working on the file for an hour only to be told it was Read Only and they can’t save their work.  Hope what I am asking/raising makes sense and would appreciate some guidance.  Thanks  Read More

​