Collaborate on Excel workbooks at the same time with co-authoring

Co-authoring in Excel allows multiple users to work on a workbook simultaneously, making it easier to collaborate and update content in real-time. This feature is available when you use Excel with a cloud service like OneDrive or SharePoint. It allows different users to edit the workbook at the same time, see each other’s changes, and communicate without interrupting each other.

Steps to Collaborate on Excel Workbooks with Co-Authoring

1. Save the Workbook to OneDrive or SharePoint

For co-authoring to work, your workbook must be saved in a cloud location like OneDrive or SharePoint.

1. Save the Workbook to OneDrive or SharePoint:
   • Open your workbook in Excel.
   • Go to the File tab and select Save As.
   • Choose OneDrive or SharePoint as the save location, and save your workbook there.

2. Share the Workbook with Others

Once the workbook is saved to a cloud service, you can share it with others.

1. Click on the Share Button:
   • In Excel, click the Share button located in the top-right corner of the window.
2. Enter the Email Addresses:
   • Type in the email addresses of the people you want to collaborate with.
   • Set the permission level (e.g., Can Edit or Can View).
3. Send the Invitation:
   • Once you’ve set the permissions, click Send. Alternatively, you can Copy Link and share it via other communication channels.

3. Collaborate in Real-Time

Once others have access to the workbook, you can all start editing the document simultaneously. Here’s how real-time collaboration works:

1. View Who’s Editing:
   • When someone is editing the workbook, you’ll see their name or a colored indicator next to the cell they’re working on.
2. See Changes in Real-Time:
   • Changes made by any collaborator will be reflected instantly. This includes text, formulas, formatting, and even cell insertions or deletions.
3. Track Changes:
   • You can see which collaborator made specific changes in the workbook. Their name will appear near any changes they’ve made.
   • If you hover over a cell that’s being edited, you’ll see a notification about who is working on that cell.
4. Use Comments for Communication:
   • To leave messages or ask questions within the workbook, you can use Comments or Notes (formerly Comments in older versions).
   • Go to the Review tab and click New Comment to add your input.
   • Collaborators can reply to comments, making it easy to have conversations within the document.

4. Resolve Conflicts

Sometimes, multiple people may try to edit the same cell or range of cells. Excel handles this by showing a Conflict Resolution prompt when the same part of the workbook is being edited by multiple users at the same time.

• Resolve Conflicts: If there’s a conflict, Excel will prompt you with options to merge or overwrite changes. You can either accept the other user’s changes or keep your own, depending on the situation.

5. Version History

In case you need to review or restore a previous version of the workbook, you can use the Version History feature.

1. View Version History:
   • Go to the File tab, select Info, and then click Version History.
   • This will show all previous versions of the workbook, including who made each change and when.
2. Restore a Previous Version:
   • If necessary, you can revert to an earlier version of the workbook by selecting the version from the list and clicking Restore.

6. Notifications and Updates

As changes are made, you can also receive notifications about edits, especially if someone makes significant changes or comments.

• Set up Notifications:
  • On OneDrive or SharePoint, you can configure activity alerts to notify you when there are changes to the workbook.

Best Practices for Co-Authoring in Excel

To make co-authoring more efficient and prevent potential issues, follow these best practices:

1. Avoid Working on the Same Cell: Try to avoid editing the same cells at the same time to minimize conflicts. Instead, divide work by areas of the workbook or by specific tasks.
2. Communicate with Comments: Use comments for discussions or clarifications, especially when working with others who might not be familiar with the workbook’s structure.
3. Keep the Workbook Organized: Structure the workbook clearly so that each person knows where to work and avoids interfering with others’ sections.
4. Regularly Save the Workbook: While changes are saved automatically, it’s a good habit to periodically click Save to ensure nothing is missed.
5. Use a Table or Range Format: Formatting your data in tables or named ranges makes it easier to collaborate, as the data is structured and easier to manage.

Co-Authoring Features in Different Excel Versions

Co-authoring works in both Excel for Microsoft 365 and Excel Online. However, it’s important to note that:

• Excel 2019 and earlier versions don’t support real-time co-authoring unless the workbook is saved in OneDrive or SharePoint and opened in Excel Online or a modern version of Excel for collaboration.
• Excel Online allows the most seamless collaboration because it’s web-based and built for real-time updates, while Excel for Microsoft 365 also supports co-authoring with additional features like version history.

Conclusion

Co-authoring in Excel enables efficient teamwork and collaboration by allowing multiple users to work on the same workbook simultaneously. By saving your workbook to OneDrive or SharePoint, you can share it with others, track real-time changes, and use comments for seamless communication. It’s a powerful feature for anyone working in a team and needing to analyze or edit Excel data collaboratively.