coauthoring

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...

Good morning everybody, I am trying to set up a document that is shared by 3 users. I need the document to be present on all 3 user's OneDrives so that when we make a change to our individual version, all 3 versions will reflect the changes. Is this possible? If not, does an idea as to how this...

I have a desire to share two workbooks that work in concert with one another. One largely contains the macros that drive the application and the other the data created and used by the application workbook. I need to be able to have the same pair of workbooks open on two machines such that when...

Hi, I have created a client manager in excel 2013 at work which uses the shared workbook feature. I need to use drop down lists so all the data validation needs to be set up before i share the workbook. If we make any mistakes we have to unshare the workbook, copy and paste the 'data validation...

Hi, I have created a shared workbook in Excel 2013 to use as a client manager at work. I have many columns with drop down menus. Sometimes mistakes happen and the data validation for the drop down is removed. This can be fixed by asking everyone to close, un-sharing, copy and paste 'data...

Good evening all, I am looking into rolling out a sharepoint adoption at our company, using the co-authoring capabilities of Excel 2016 with OneDrive/Sharepoint to enable sharing of macro-enabled workbooks with userforms etc (at last we can do this!) I am however hitting a snag with...