From personal experience and reviewing this forum and even answers.microsoft.com, it seems that the co-authoring feature has some problems. I have two workbooks I share from Teams, both have macros and tables and one uses userforms for data entry. One, however, will experience random Upload...
I have a rather complex Excel workbook with many complicated array formulas, pivot tables and charts, and macros that I share on Teams using the Excel co-authoring capability. Of course, since the workbook contains macros, my concurrent users are opening it in the desktop app. The workbook...
Does anyone know exactly how form controls (e.g. checkboxes) work when co-authoring.
I don't link them to a cell and use an assigned macro to get the checkbox status directly from the object
(cbValue = Worksheets("APRA CPG 234 Tracking").Shapes("CheckBoxName").ControlFormat.Value).
So the...
Dear All,
Just wondering about the new function in Excel for Co-Authoring, is it possible to Co-Authoring a file in the local share drive rather than cloud like onedrive?
Or we need to use the old way to do the share workbook?
Cheers,
Peter
Hi,
I am currently working on a template to be shared among several people within the organization. It is suppose to be stored in a sharepoint using the web. The idea was to generate a backlog where you could see all changes that people have been doing. The purpose for tracking the changes is...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.