You need to work on a spreadsheet with colleagues without sending files back and forth. Co-authoring in Excel allows multiple people to edit the same workbook simultaneously. This feature is part of Microsoft 365 and requires the file to be saved to a shared cloud location. This article explains how to set up and use real-time collaboration.
Key Takeaways: Co-Authoring in Excel
- Save to OneDrive or SharePoint: This is the primary requirement for enabling real-time co-authoring in Excel.
- Share button in the top-right corner: Use this to invite people and set their editing permissions for the workbook.
- AutoSave toggle: This must be turned on for changes to be saved and visible to other co-authors instantly.
What Excel Co-Authoring Does
Co-authoring is a feature for Microsoft 365 subscribers. It lets several users open and edit the same Excel file at the same time. Everyone sees each other’s changes as they happen. The feature works on the Excel desktop app for Windows and Mac, the web version in a browser, and the mobile apps.
For co-authoring to function, the Excel workbook must be stored on a Microsoft cloud service. This includes OneDrive, OneDrive for Business, or SharePoint Online. These services handle the merging of changes from all editors. You cannot use co-authoring with files stored only on your local computer or a standard network drive.
Prerequisites for Co-Authoring
You and your collaborators need a Microsoft account or a work/school account with a Microsoft 365 plan that includes Excel. All users must have permission to edit the file. The file format must be the modern .xlsx format. Older formats like .xls do not support real-time co-authoring.
Steps to Start Co-Authoring
Follow these steps to prepare a workbook and invite others to edit with you.
- Save your workbook to the cloud
Open your file in Excel. Go to File > Save As. Select your OneDrive, OneDrive for Business, or a SharePoint Online site. Save the file there. The AutoSave toggle in the top-left corner should turn on automatically and show “On.” - Share the workbook with collaborators
Click the Share button in the top-right corner of the Excel window. In the Send Link panel, enter the email addresses of the people you want to invite. Click the drop-down menu that says “Can edit” to confirm they have editing rights. You can also copy a link to send directly. Click Send. - Notify collaborators and begin editing
The invited users will receive an email with a link to the file. When they open it, you will see their presence. A colored avatar with their initials will appear in the top-right corner. You can now all edit the workbook. Each person’s selected cell will be outlined in their assigned color.
Using Co-Authoring Features
Once co-authoring is active, you can use specific collaboration tools.
- See who is editing and where
Look at the top-right corner for colored avatars. Click on a person’s avatar to see which cell or range they have selected, highlighted in their color. This helps avoid editing conflicts on the same cell. - Use comments for discussion
Go to the Review tab and click New Comment. Type your message and post it. Comments are threaded and notify the person you @mention. All co-authors can see and reply to comments in real time. - View change history
Go to File > Info. Under Version History, click See All Versions. This opens a panel showing saved versions of the file. You can open a past version to see what changed and restore it if needed.
Common Co-Authoring Mistakes and Limitations
AutoSave Is Turned Off
If the AutoSave toggle is off, your changes are not saved to the cloud. Other co-authors will not see your edits. Always check that AutoSave is on. If it is off, you may be working on a local copy. Save the file to OneDrive or SharePoint again to re-enable it.
Editing Conflicts on the Same Cell
If two people type in the same cell at the same time, Excel gives priority to the person who presses Enter first. The second person will see a notification that the cell was changed by someone else. Their entry will not be saved. To avoid this, communicate with your team or use the colored selection outlines to see which cells others are using.
Features Not Available During Co-Authoring
Certain actions will temporarily block others from editing. These include creating or editing a table, inserting or deleting worksheets, and working with certain data types. When you perform such an action, a yellow bar appears at the top of the window. It tells others you have exclusive access. The block is released when you finish the task.
Co-Authoring in Excel Desktop vs. Excel for the Web
| Item | Excel Desktop App | Excel for the Web |
|---|---|---|
| Required software | Microsoft 365 Excel app installed | Modern web browser only |
| Feature availability | Full Excel feature set | Subset of features, simplified interface |
| Real-time presence | Colored avatars and cell selection highlights | Colored avatars and cell selection highlights |
| Offline editing | Possible, syncs when back online | Not available |
| Best for | Complex analysis, advanced formulas, macros | Quick edits, viewing, basic updates from any device |
You can now edit spreadsheets with your team in real time without version confusion. Remember to always save your file to OneDrive or SharePoint first. For next steps, try using @mentions in comments to direct questions to specific collaborators. An advanced tip is to use the Version History feature to create a manual checkpoint before making major changes to the workbook structure.