I’m relatively new to co authoring in excel as a collaboration tool and have found some behaviour that I can’t seem to find anything about.
My workbook is simple but makes use of some vba event handler subroutines and has some checkboxes with Marcos assigned. Simply put I've found that if I on one machine edit a macro in the VBE or add a new checkbox, the person on the other machine sometimes gets an upload error indicating that I am doing something in VBA or using forms controls (not activex if that’s important).
I haven’t been able to find and references to these situations but it means the6 other person loses their edits.
Empirically it seems to be a limitation of co authoring but the question is why? MS apparently knows about this because excel produces very explicit error messages, clearly indicating either VBA or forms controls and my user ID.
I hope someone can provide an explanation.
Many Thanks
Max
My workbook is simple but makes use of some vba event handler subroutines and has some checkboxes with Marcos assigned. Simply put I've found that if I on one machine edit a macro in the VBE or add a new checkbox, the person on the other machine sometimes gets an upload error indicating that I am doing something in VBA or using forms controls (not activex if that’s important).
I haven’t been able to find and references to these situations but it means the6 other person loses their edits.
Empirically it seems to be a limitation of co authoring but the question is why? MS apparently knows about this because excel produces very explicit error messages, clearly indicating either VBA or forms controls and my user ID.
I hope someone can provide an explanation.
Many Thanks
Max