Forum Discussion

Copper Contributor

Sep 10, 2018

Edit macro enabled workbook simultaneously in share point

We have macro enabled excel workbook saved in the share point. We have 4 users who want to work on this same file simultaneously and make our respective changes at the same time. But only the per...

SharePoint Online

Andrew Brewster

Copper Contributor

Sep 10, 2018

General requirements / help is here:

https://support.office.com/en-us/article/document-collaboration-and-co-authoring-ee1509b4-1f6e-401e-b04a-782d26f564a4

plus more specific info for Excel is here; macro-enabled workbooks (.xlsm) are supported

https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

You may have to alter library settings for check-in, check-out so that no one person can open a file exclusively and block others from doing so.

Mudasir Ahamed

Copper Contributor

Sep 11, 2018

Hi Andrew,

Thank you for your response on this issue. I did go through the link you shared but could not find a solution that stated we can simultaneously edit a macro enabled work book at the same time in share point. I also tried doing the lock In/Out options and some library settings but not solution yet.

The file we have is also in XLSM format that was mentioned in one of the links you shared. We are looking for a workaround where all 4 people can work at the same time on this one file without having to lock any of us while we edit. The reason is, the data is divided into four different sets and each user will edit their own data.

Please let me know if we have a resolution on this issue.

Thanks,

Mudassir