Chapter 28

Collaborating in Excel

The rise of working remotely in 2020

Storing documents in the cloud

Sharing documents with others

Editing the same workbook at the same time

Seeing who else is editing using presence

Filtering and sorting with Sheet Views

Using threaded comments, mentions, and assigning tasks

Tracking who did what in the workbook

Microsoft introduced the ability for multiple people to collaborate on a worksheet back in 2017. The first release of any product from Microsoft has rough edges. As I am writing this, the collaboration tools are four years old. Microsoft has improved the collaboration tools, offering better commenting, mentions, and show changes. As of 2021, collaboration is fairly stable for files of 1 MB or less ...

Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.