Share an Excel 365 Workbook for Real-Time Collaboration
Question details
The user needs to share an Excel 365 workbook with someone from another organization for simultaneous editing.
- Product
- Microsoft Excel 365 with OneDrive or SharePoint
- Device & OS
- not provided
- Scenario
- The workbook owner wants to give an external collaborator access and allow both users to edit the same file in real time.
- Observed behavior
- The workbook must remain stored in OneDrive or SharePoint so edits synchronize between Excel for the web or the desktop application.
Confirm that the workbook is saved in OneDrive or SharePoint and that your organization permits external sharing. Check whether the recipient should have editing permission rather than view-only access.
Share the Excel 365 workbook from OneDrive or SharePoint
Use this method when an external collaborator needs to edit the same cloud-hosted workbook at the same time.
Real-time collaboration requires the workbook to stay in OneDrive or SharePoint. Sharing a local copy or an email attachment creates separate files and does not synchronize edits between users.
Open the workbook from OneDrive or SharePoint in Excel 365, and verify that the file is saved in the cloud location.
In Excel, select File > Share, or select the Share button near the upper-right corner of the workbook.
Choose the appropriate link settings, such as Anyone with the link can edit if your organization's sharing policy allows it. Otherwise, enter the recipient's email address and assign Can edit permission.
Select Copy link or Send, then provide the sharing link to the person from the other organization.
The recipient can open the link in Excel for the web or select Open in Excel to use the desktop application. Keep the workbook in OneDrive or SharePoint while both users work.
Try WPS Office for Lightweight Excel Workbook Editing
WPS Office is a free, lightweight alternative for opening, editing, and sharing Excel-compatible workbooks. Its familiar interface and support for Microsoft formats make it easier to move from Excel, although OneDrive or SharePoint permissions remain Microsoft 365 features.
Frequently Asked Questions
Can someone outside my organization edit an Excel 365 workbook?
Yes, if your organization's OneDrive or SharePoint settings allow external sharing. In Excel, select File > Share, configure an editing link or enter the person's email address, and send the link.
Why must the workbook remain in OneDrive or SharePoint?
Excel's real-time collaboration depends on a single cloud-hosted file. If users edit downloaded copies or email attachments, their changes will not synchronize automatically.
Can the recipient edit the workbook without desktop Excel?
Yes. The recipient can open the shared link in a browser and edit the workbook with Excel for the web. If they have the desktop application, they can select Open in Excel instead.
What should I do if the external user can only view the workbook?
Open the sharing settings from File > Share and check the permission assigned to the link or recipient. Change it to Can edit if your organization's external-sharing policy permits editing.
