joshking247
New Member
- Joined
- Jan 11, 2018
- Messages
- 3
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 validation only', and then re-sharing.
Some of us have office 2016 and cannot unshare and reshare because this has been replaced with coauthoring. I would like to upgrade the all machines to 2016 but I can't find any good articles on the differences between 'shared workbook' and 'coauthoring'.
Could someone please advise me on how I could carry our the above process in 'coauthoring' in 2016?
Also, would anyone be able to highlight the main differences between these two features? I couldn't find much on a web search.
thanks!!
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 validation only', and then re-sharing.
Some of us have office 2016 and cannot unshare and reshare because this has been replaced with coauthoring. I would like to upgrade the all machines to 2016 but I can't find any good articles on the differences between 'shared workbook' and 'coauthoring'.
Could someone please advise me on how I could carry our the above process in 'coauthoring' in 2016?
Also, would anyone be able to highlight the main differences between these two features? I couldn't find much on a web search.
thanks!!