Change from Shared Workbook to Coauthoring

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

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

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.
Go back
Back
Top