Are Co-Authoring & UserForms compatible? Constant issue with merging changes.

[gravanoc]

I'm looking for any information about co-authoring & UserForms. Specifically, the file is on a SharePoint server, if that makes any difference. Also, the user's version is 365 for Enterprise, while I am 365 for Business.

There are several forms in a complex file I've developed, and everything works fine while editing alone, but if another user is editing the file simultaneously, there are constant "we cannot merge your changes with xxx" & the AutoSave option turns off. This happens when one user is using a UserForm & the other is doing anything else.

Any guidance on this would help. Thanks.

 

[Dan_W]

Does it matter if the Userform is being shown modally or not? If the Userform were being shown modally, I wonder if the reason SharePoint can't merge the changes is because the Userform version is "in use"... just a thought.

 

[gravanoc]

Does it matter if the Userform is being shown modally or not? If the Userform were being shown modally, I wonder if the reason SharePoint can't merge the changes is because the Userform version is "in use"... just a thought.

It is being shown modally. I can try to set it to False & see if that makes a difference. Thanks!

 

[skyshow1]

gravanoc - I am wondering if you have any tips that have helped with your constant "we cannot merge your changes with xxx'" issues. My experience shows that Modeless forms do not cause an issue. I am running into the same problem with multiple users on Excel 365 for Enterprise and a co-authored spreadsheet on Sharepoint. The conflicts do not seem to come from editing the same cells in the spreadsheet. Any tips or insights your have found would be helpful. Thanks!