New Co-authoring Feature in Excel 2016
With a software update to certain versions of Excel in late summer 2017, Microsoft replaced the share workbook and track changes features with the new co-authoring feature. Co-authoring allows you to collaborate in real time, where you can see everyone who is editing the workbook and the areas of the workbook they are working on.
To use the co-authoring feature, every person who is sharing the file must have a version of Excel that supports co-authoring. Versions that support co-authoring are Excel 2016 for Windows, Excel 2016 for Mac, Excel Online, Excel for Android, Excel of iOS, and Excel Mobile. If any of the users who are sharing the file do not have one of these versions of Excel, the co-authoring feature will not work for any of the users sharing the file.
To co-author a workbook, you must be signed into Office with your Office 365 subscription and you must create or upload the workbook on OneDrive, OneDrive for Business, or a SharePoint Online library. Once the workbook has been created or uploaded, buttons in the top-right corner of the ribbon allow users to access the co-authoring features and view all workbook activity. To invite colleagues to co-author a file, click the Share button on the ribbon, type their email addresses, and then choose a cloud location.
If you are using one of the above-mentioned versions of Excel and you want to share a workbook on a network drive, you can add the Share (Legacy) and Track Changes (Legacy) features to the ribbon or Quick Access Toolbar. See the separate Content Conversations entries on those features for instructions on installing those features.
Advanced Microsoft® Excel® 2016, Chapter 14, Sections 14.3 and 14.4 (textbook pages 685–693)
Benchmark series, Microsoft® Excel 2016, Level 2, Chapter 6 (textbook pages 147–148)