Microsoft Excel 2016 – Co-authoring Workbook Sharing and Collaborating

Co-authoring lets you work smarter and faster by allowing you to keep your document in one place, in the Cloud, while providing easy access and editing capabilities for your team, or viewing for people outside of your organization.

Simple Sharing of a Workbook:

Choose Share on the ribbon to share your spreadsheet with others on SharePoint, OneDrive, or OneDrive for Business.

Share Workbook to Collaborate:

When you share a workbook, multiple users can't work in the same file at the same time. Instead, you merge changes from one or more copies of that workbook back into the one that you shared with Compare and Merge Workbooks (to do this, first add this command to your Quick Access Toolbar).

These changes bring together two key aspects of collaboration:

·      who has access to a given document and who is currently working with you on the document.

·      now you can view both pieces of information in one place from the Share dialog box.