To share an Excel workbook in Microsoft 365, save it to OneDrive or SharePoint, select Share, choose who can open it and whether they can edit, then send an invitation or copy a link. This lets people work in the same cloud-stored file, with changes appearing for collaborators as they edit. You will need Excel for Microsoft 365 and permission to save files to a OneDrive or SharePoint location; recipients need access to the account or link you share.
What You’ll Need
- A Microsoft 365 account with OneDrive or access to a SharePoint document library. For work or school accounts, your organization may control which sharing options are available.
- The workbook saved in the cloud, ideally as an Excel workbook (.xlsx). Files stored only on your computer cannot use Microsoft 365 coauthoring until you save or upload them to OneDrive or SharePoint.
- The email addresses of the intended recipients, or a link-sharing option that your organization allows. Recipients may need to sign in with an approved Microsoft account.
Step-by-Step
- Check that you have the right workbook and account. Open the workbook in Excel for Microsoft 365 on Windows and confirm that it is the file you intend to share. If you use both personal and work accounts, check the account shown in the upper-right corner of Excel. A file in a personal OneDrive and one in a company SharePoint site can have different access rules. Sharing grants other people access to the workbook and possibly its contents, so check for confidential information, hidden worksheets, and outdated copies before continuing.
- Save the workbook to OneDrive or SharePoint. If the file is on your computer, select File > Save As, choose your OneDrive account or a SharePoint location, select a folder, and save. You can also use the Share button in some current Excel builds; Excel will prompt you to save or upload the workbook to a cloud location first. Wait for the save or upload to finish. If the AutoSave switch appears, turn it on for the cloud file so changes are saved as you work. If your organization requires files to stay in a particular SharePoint library, save there rather than in personal OneDrive.
- Open the sharing controls. Select Share near the upper-right corner of the Excel window. In the sharing panel, choose Share if Excel first shows options such as copying a link or managing access. The wording and panel layout can vary slightly between Microsoft 365 updates, but the Share button opens the workbook’s access controls. If Excel asks you to sign in, use the account that owns the cloud file or has permission to share it.
- Invite specific people when you want controlled access. In the sharing box, type one or more names or email addresses in the recipient field. Select the suggested contact only after checking that it is the correct person, especially when names are similar. You can add a short message to explain what the workbook is for or which sheet needs attention. Inviting named people is generally safer than creating a link that can be forwarded, and it makes it easier to remove a particular person’s access later.
- Choose whether recipients can edit or only view. Before sending, open the permission control in the share panel. It may show Can edit by default. Choose Can view if people should read or download the workbook without changing the shared file, or leave editing enabled if they need to update it. Some organizations offer additional controls, such as blocking downloads for view-only links; these are not available for every account or file. Check the permission setting for each invitation instead of assuming it carries over from an earlier share.
- Send the invitation or create a link. To invite named people, select Send. Excel emails them a link to the cloud workbook; it does not normally attach a separate copy. To share by link, select Copy link or open the link settings first, choose the audience your account allows, and set its permission. Options can include people in your organization, specific people, or anyone with the link. Choose the narrowest audience that meets your needs, then select Apply if shown and Copy. Paste the link into a message only for the intended audience. If the option for anyone is missing, your organization may have disabled it.
- Confirm access and explain how to open the file. Send the copied link through an appropriate channel, or ask invited recipients to check their email. They should open the link while signed in to the account that received permission. A prompt to request access usually means the person is using a different account, the link is restricted to another audience, or access has not been granted yet. Ask recipients not to download and re-upload their own copies if you want everyone editing one shared workbook; separate copies do not merge their changes automatically.
- Collaborate in the shared workbook and review access later. Once collaborators open the cloud file, their names or initials may appear in Excel, and edits can appear as they work. Depending on the workbook and settings, you may see their selections or changes in real time. Save your own edits and give the file a moment to sync before closing Excel, particularly on a slow connection. To review or change permissions, select Share and look for Manage access or the access details in the sharing panel. Remove people who no longer need access, or change a link’s permission when the project ends.
On Mac or Excel for the web: The main process is the same: save the file to OneDrive or SharePoint, use Share, choose recipients or link settings, and set editing rights. Excel for the web runs in a browser, so there is no desktop Save As dialog in the same form; upload or move the workbook into OneDrive or SharePoint first, then open it there. On Mac, button placement can differ slightly, but use the Share control rather than looking for the older legacy sharing command.
Common Mistakes
- Sharing a local copy. A workbook saved only to Documents or the desktop is not a cloud collaboration file. Upload or save it to OneDrive or SharePoint before inviting people, then confirm the cloud copy is the one you are editing.
- Giving edit access by default. Editors can change cells, formulas, formatting, and—in some circumstances—workbook structure. Choose view access for readers, and grant editing only when it is needed. If a recipient needs to update just a small area, explain which cells to change; worksheet protection may help prevent accidental edits but is not a replacement for access control.
- Using a broad link without checking its audience. A link that works for anyone who receives it can be forwarded. If you do not need broad access, choose specific people or people in your organization. Treat a link with edit rights like a key to the shared workbook.
- Assuming an email invitation is an attachment. The invitation usually points to the online file. If someone downloads a copy and edits it offline, those edits may not appear in the shared workbook. Ask them to open the link in Excel or a browser and verify the file name and location.
- Sharing the wrong version or exposing hidden content. Check the file name and folder before sending. Review hidden sheets, comments, and data that should not be shared; hiding a worksheet does not make its contents private. If you need to share a sanitized copy, create and inspect a separate workbook rather than assuming hidden material is inaccessible.
Tips
- Use a descriptive file name and folder. A name such as Quarterly Sales Review is easier for collaborators to recognize than Book1.xlsx. Store team files in the appropriate SharePoint location so access follows your organization’s normal ownership and retention practices.
- Tell collaborators what to do. Include a short note identifying the purpose of the workbook, the worksheet they should use, and whether they should edit or comment. If multiple people are entering information, agree on a format and avoid changing column headings or moving rows while others are working.
- Keep a clear version history. OneDrive and SharePoint can retain previous versions, depending on account settings. If an important change is made by mistake, use the file’s version-history controls in OneDrive or SharePoint to review or restore an earlier version. Check with your organization before relying on a particular retention period.
- Use named invitations for sensitive work. Sharing with selected people makes it easier to identify who has access and revoke it. For a temporary project, set a reminder to review permissions when the work is finished, and remove outdated invitations or links.
- Allow syncing to finish. Before shutting down Excel or disconnecting from the internet, check that the workbook has saved. AutoSave and the cloud status indicators can help, but a network interruption may delay updates. Avoid editing two downloaded copies and expecting Excel to combine them automatically.
Troubleshooting
The Share button is missing or disabled: Confirm that you are signed in to Microsoft 365 and that the workbook is saved in OneDrive or SharePoint. Your organization may restrict sharing, or you may have read-only access to the file. Ask the file owner or Microsoft 365 administrator to confirm that you have permission to share it.
Excel says the workbook must be uploaded or saved first: Follow the prompt to save it to a cloud location you are allowed to use. If the workbook is open from an email attachment, a temporary folder, or a network drive, save a copy to OneDrive or SharePoint and share that cloud copy. Verify its location before sending a link so recipients do not end up with access to a different file.
A recipient sees an access request or cannot open the link: Check that the invitation was sent to the address they are using and that the link’s audience matches their account. For a specific-people link, the recipient may need to sign in as the named person. If appropriate, open Share > Manage access, update the invitation or link settings, and send a fresh link. Do not change a restricted link to anyone-with-the-link access just to bypass a sign-in issue unless that broader access is acceptable.
People can open the workbook but cannot edit: Review the invitation or link permission and change it to Can edit if editing is intended. Also check whether the workbook is protected or opened in read-only mode. If the file belongs to someone else or a SharePoint team, the owner or site administrator may need to grant edit rights.
Changes are not appearing for everyone: Confirm that each person opened the same OneDrive or SharePoint file, not a downloaded copy or an older link to another workbook. Check internet connectivity and wait for pending saves or uploads to complete. Close and reopen the cloud file if it appears stuck. If a person edited offline, they should reconnect and follow Excel’s prompts carefully; keep separate copies until any conflicting edits are resolved.
Link-sharing options are unavailable: The owner’s organization may block external sharing or links for anyone. Use an approved method, such as inviting a colleague by their work address, or ask the Microsoft 365 administrator about the organization’s policy. A workbook’s sensitivity label or other security settings can also limit sharing.
Frequently Asked Questions
Can multiple people edit an Excel workbook at the same time?
Yes, when the workbook is stored in OneDrive or SharePoint and shared with editing permission. Collaborators should open the same cloud file in a supported, current version of Excel or Excel for the web. If someone works on a separate downloaded copy, their edits will not automatically appear in the shared workbook.
Can I share Excel without OneDrive?
For Microsoft 365 coauthoring, the workbook needs to be stored in OneDrive or SharePoint. You can send a file as an email attachment or place it in another storage service, but that is not the same as sharing one live Microsoft 365 workbook, and separate copies can quickly become inconsistent.
Can I share a workbook with someone who does not have Excel?
They may be able to open the link in Excel for the web using a browser, depending on the file’s permissions and the recipient’s account. They still need access to the link and may be asked to sign in. If they only need to read the information, set view permission and have them try the browser version.
How do I stop sharing an Excel file?
Select Share and open Manage access or the file’s access details. Remove a named person or delete or change a shared link, if those controls are available to you. If you shared multiple links or invited people separately, review each entry; removing one person does not necessarily invalidate every other link.
Will recipients see my changes automatically?
People who are editing the same cloud workbook can generally see saved changes as Excel syncs them. Timing depends on the connection and the workbook. If the changes do not show, check that everyone has the same file open and that there are no pending save or sync warnings.
Is sharing a link safer than sending the workbook as an attachment?
A cloud link can keep everyone working from one current file and lets you manage access later. Its safety depends on the audience and permissions you choose: a link limited to named people is more controlled than a link that anyone can use. An attachment creates a separate copy that you cannot update or revoke in the same way.
Related
- How to Randomize in Excel: Shuffle Lists and Numbers
- How to Rank in Excel When There Is a Tie: Two Methods
- How to Quick Repair Excel on Windows: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Archive a Lot of Emails in Outlook at OnceTo archive a large batch in Outlook, narrow the message list with a search or folder filter, select…
- How to Double Space in Microsoft Word on Any DeviceTo double-space text in Microsoft Word, select the text, then choose Home > Line and Paragraph Spacing >…
- Disable Autofit in Excel: Keep Rows and Columns FixedTo stop a PivotTable from changing column widths after each refresh, select it, open PivotTable Analyze > Options,…
- Export an Excel Table as a Picture: Step-by-StepTo export an Excel table as a picture in Microsoft Excel for Microsoft 365 on Windows, select the…
- Excel Conditional Formatting for Dates Before TodayTo highlight dates earlier than today in Excel for Microsoft 365 on Windows, select the date cells (for…
- Excel Solver in Google Sheets: Tools, Setup, and LimitsGoogle Sheets does not include Microsoft Excel’s built-in Solver, so there is no native Solver button or menu…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.