To share an Excel file, save it to OneDrive or SharePoint, select Share in the upper-right corner of Excel, and invite people or copy a sharing link. Choose whether recipients can edit or only view the workbook before you send the invitation.
Share an Excel workbook from Windows
For Microsoft Excel for Microsoft 365 on Windows, the simplest way to share a workbook is to store it online first. A workbook saved only on your computer cannot be shared through Excel’s cloud collaboration controls until it is uploaded to OneDrive or a SharePoint library.
- Open the workbook and save it as an Excel workbook, usually with the .xlsx file extension. If it is not online already, use File > Save As and choose OneDrive or a SharePoint location. Sign in to your Microsoft account or work account if Excel asks.
- Select Share near the upper-right corner of the Excel window. If the workbook has not been saved online, Excel will prompt you to save or upload it before continuing.
- In the sharing window, enter the names or email addresses of the people you want to invite. You can add a message if useful.
- Check the permission setting before sending. Choose whether recipients can edit or view the workbook, then select Send.
Excel sends an invitation with a link to the online file. The recipient opens that workbook rather than a separate attachment, so collaborators can work from the same stored copy. You can also select Copy link in the sharing window and send the link yourself through email or another messaging service.
Choose who can open the link
A sharing link is convenient, but the people who can use it depend on its link settings. Select the link or permission control in the sharing window to review available choices. Common options include access for anyone with the link, people in your organization, or specific people. The options shown can vary according to your Microsoft 365 account, organization policies, and the file’s storage location.
Use a specific-people invitation when the workbook contains information that should reach only named recipients. An organization-wide link may be suitable for an internal team, but it can be accessible to more colleagues than you intend. An anyone-with-the-link option is easier to forward and may allow access outside your organization, so avoid it for confidential or personal information unless that access is appropriate.
Check the permission level as well as the audience. Can edit lets recipients change the workbook; a view-only option lets them read it without editing the shared copy. If Excel offers a choice to block downloading for a view-only link, it can add a restriction, but it does not prevent someone from photographing or otherwise copying information they can see. Link controls are not a substitute for careful decisions about what the workbook contains.
Collaborate on the same workbook
When a workbook is in OneDrive or SharePoint and collaborators have permission, supported versions of Excel can let multiple people work in the same file. This is called co-authoring. Participants may see one another’s presence or selected cells, and changes can appear for others as they are made. The precise indicators depend on the Excel version and connection.
For a smooth session, use the current Microsoft 365 version of Excel or Excel for the web, keep an internet connection, and leave AutoSave on when it is available. The AutoSave switch appears in the Excel title area for supported cloud files. If a collaborator is temporarily offline, their edits may not reach everyone until the connection returns. Wait for syncing to finish before closing or moving the file, especially after a network interruption.
Co-authoring is different from sending separate copies. If two people edit downloaded copies and email them back and forth, Excel does not automatically combine all their changes into the original. That can create competing versions, such as a file named with a person’s name or a version number. Use the shared cloud workbook when you want a central working copy; make a separate copy only when you intentionally need an independent version.
Share from Excel for the web or a Mac
In Excel for the web, open the workbook from OneDrive or SharePoint and select Share. Enter people’s names or email addresses, review the access setting, and send the invitation, or copy a link. The web version is useful when a recipient does not have the desktop app available, though some features and workflows differ from desktop Excel.
Excel for Mac also supports sharing cloud-stored workbooks. Save the file to OneDrive or SharePoint, then use the Share control in Excel and review the recipient and permission settings before sending. The precise layout can differ from Windows, but the key requirement is the same: the file must be in a supported online location for people to collaborate on one shared copy. A file stored only on the Mac remains a local file until it is uploaded.
People can also open an invitation link in a browser, depending on their access and the link’s settings. If a colleague cannot use the desktop application, Excel for the web can be a practical option for viewing or making supported edits. If they need a feature that is unavailable in the web version, they may need to open the workbook in desktop Excel.
Sharing a workbook is not sharing one worksheet
Excel’s normal sharing permissions apply to the workbook file, not separately to each worksheet. If you share a workbook with editing permission, do not assume that a particular recipient can edit only one tab. Hiding a worksheet or protecting a sheet can help prevent accidental changes, but neither should be treated as a secure way to conceal sensitive data from someone who can access the workbook.
If different groups must see different information, consider preparing separate workbooks that contain only the information each group needs. Another option is to keep the source data in a controlled location and distribute appropriate reports or exports. Before sharing, inspect hidden sheets, hidden rows and columns, comments, and other content that may reveal information you did not intend to disclose.
Sheet protection and workbook protection can still be useful for limiting routine edits. For example, a template owner might protect formula cells so a collaborator does not accidentally overwrite them. Treat that as editing control, not as a replacement for access permissions or data removal.
Fix common sharing problems
- The Share button is unavailable or asks you to save: Save or upload the workbook to OneDrive or SharePoint, then try again. Confirm that you are signed in to the account that has access to that location.
- A recipient gets an access-denied message: Check that you invited the right email address and that the person is signing in with the account associated with the invitation. If you used a specific-people link, forwarding it to another person may not grant that person access.
- You cannot choose an anyone link: Your Microsoft 365 organization may disable that type of external sharing. Ask the SharePoint or Microsoft 365 administrator about permitted options rather than trying to bypass the policy.
- Changes are not appearing: Check that each person opened the same cloud file, is online, and has finished syncing. Someone working in a downloaded copy may be editing a different version.
- A workbook opens read-only: The link may grant view access, or the recipient may not have permission to edit. Review the sharing settings and send an edit-enabled invitation if that person should be able to change the file.
If you change a person’s access or replace an old link, make the change through the file’s sharing controls rather than assuming an earlier message has been recalled. A link already sent may remain usable until its access is changed or revoked, depending on its settings.
Share safely and manage access later
Before sending a workbook, confirm that its contents are appropriate for every person who will receive access. Use the narrowest audience and lowest permission level that still lets people do their work. For example, a team member who only needs to check figures may need view access, while the person maintaining the calculations may need edit access.
After sharing, use the workbook’s sharing or access-management controls in Excel, OneDrive, or SharePoint to review who has access and, where available, remove a person or change a link’s permissions. For a work or school account, an administrator can impose additional restrictions. If you accidentally send a link too broadly, adjust or revoke access promptly and follow your organization’s procedures for sensitive information.
For a one-time handoff where people do not need to collaborate, sending a separate copy can be more appropriate. Keep in mind that a downloaded copy is no longer controlled by later changes to the original file’s sharing permissions. Decide whether recipients need a living shared workbook or a point-in-time copy before choosing how to send it.
Alternatives to a shared Excel workbook
Use OneDrive or SharePoint sharing when people need to work together on one Excel file. If the recipient only needs to read or print the results, a PDF export can be simpler, although it is not an editable spreadsheet. If they need to enter data but should not change the workbook’s structure, a separate input form or a carefully designed, protected template may be more suitable. Those choices depend on the task and do not automatically create the same live collaboration experience as a shared workbook.
The older idea of a “shared workbook” can also refer to Excel’s legacy feature for tracking edits in a file. That is not the same as modern cloud co-authoring. For most Microsoft 365 collaboration, use a workbook stored in OneDrive or SharePoint and the regular Share controls rather than relying on legacy shared-workbook workflows.
Frequently Asked Questions
Can I share an Excel file for free?
You can share a workbook through OneDrive or SharePoint if your account has access to the service and the required sharing features. Available storage, link choices, and organization restrictions depend on the account and its settings.
Can someone edit Excel without installing Excel?
Often, yes. A recipient with suitable access can open a shared workbook in Excel for the web through a browser. Some workbook features may require the desktop application.
How do I share Excel without allowing edits?
In the Share window, change the permission from editing to viewing before sending the invitation or copying the link. Check the setting shown in the dialog because defaults can vary.
Can I share just one tab in an Excel workbook?
Standard file-sharing permissions apply to the workbook, not a single worksheet. To keep other workbook content private, create a separate file containing only the information that recipient should see.
Why can’t I share my Excel workbook with someone outside my company?
Your organization may restrict external sharing in Microsoft 365 or SharePoint. If external sharing is allowed, verify the recipient’s address and the link’s audience settings; otherwise, ask your administrator about an approved method.
How do I stop sharing an Excel file?
Open the workbook’s access or sharing management controls and remove individual recipients or revoke the relevant link if those options are available. Changing access to the online file does not erase copies someone has already downloaded.
Related
- Can AI Replace Excel Jobs? The Work It Can Do
- Calendar Timeline Template Excel: Build Your Own
- Calendar Planner Template in Excel: Build and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation: Rules, Lists, and Input TipsTo add a data validation rule in Excel for Microsoft 365 on Windows, select the cells, choose Data…
- How to Sum Just Subtotals in Excel Without Double-CountingWhen your subtotal rows contain Excel SUBTOTAL formulas, place an outer SUBTOTAL over the detail-and-subtotal range: it skips…
- Color Heat Rank in Excel with Conditional FormattingTo color heat rank in Excel, calculate each item’s rank with RANK.EQ, then apply a three-color scale to…
- How to Set Yourself Out of Office in Outlook on Any DeviceTo set yourself out of office in Outlook, turn on Automatic Replies, write your message, and—if the option…
- Remove Percentage in Google Sheets: Format or ConvertTo remove the percent sign in Google Sheets, select the cells and choose Format > Number > Number.…
- Data Validation Shortcut Key in Excel: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, then A, then V, then V to open the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.