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 worksheet_change events. I have some of these which I use to detect when values are entered in certain columns and then they will automatically populate other columns with data (such as current user, today's date etc).
I have managed to get to a point where if 2 users are signed in at the same time and one user enters data in one column (triggering the change event and therefore adding data in another column), this gets updated to the cloud and the 2nd user sees an update for the initial data that is entered (the one that triggered the event) but then nothing more is updated (the additional data that was inputted by the change event), although this appears OK on the 1st user's version. The workbook for the 2nd user will then generally stop updating and the 'Refresh' button appears at the top, saying that there is a more recent version uploaded to the cloud. The 2nd user then has to click this to close and reopen the workbook to see the same version as the 1st user.
I am also getting the same issue if any text is added into the workbook from a userform.
Does anyone know of any way to make this work? If you need any further clarification on what I'm talking about please feel free to ask!
Thanks
Dave
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 worksheet_change events. I have some of these which I use to detect when values are entered in certain columns and then they will automatically populate other columns with data (such as current user, today's date etc).
I have managed to get to a point where if 2 users are signed in at the same time and one user enters data in one column (triggering the change event and therefore adding data in another column), this gets updated to the cloud and the 2nd user sees an update for the initial data that is entered (the one that triggered the event) but then nothing more is updated (the additional data that was inputted by the change event), although this appears OK on the 1st user's version. The workbook for the 2nd user will then generally stop updating and the 'Refresh' button appears at the top, saying that there is a more recent version uploaded to the cloud. The 2nd user then has to click this to close and reopen the workbook to see the same version as the 1st user.
I am also getting the same issue if any text is added into the workbook from a userform.
Does anyone know of any way to make this work? If you need any further clarification on what I'm talking about please feel free to ask!
Thanks
Dave