Forum Discussion

Mudasir Ahamed's avatar
Mudasir Ahamed
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's avatar
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's avatar
    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

Resources