Everything You Need to Know About Co-Authoring in Excel
Co-authoring enables you and your colleagues to work on the same Excel workbook simultaneously. Everyone sees all changes in real-time, and across all devices that run Excel for Office 365, for the web, or any mobile version.
To co-author in Excel, you need the latest version of Office 365.
Share Your Workbook for Co-Authoring
To co-author a workbook, you first need to save it to OneDrive or a SharePoint Online library. To share your workbook with others, click “Share” in the top right corner.
If you haven’t already saved the workbook you want to share to OneDrive or SharePoint, you’ll be prompted to do so.
When the Share pane opens, type the email addresses of the people with whom you want to share the workbook.
Next, click the drop-down button to decide whether each person can edit or just view the workbook. You can also type a message if you’d like.
Click “Share” to send an email to everyone you invited.