How to Enable the Share Option in Excel for Collaboration

How-to basics · Updated November 20, 2026

To enable sharing in Microsoft Excel for Microsoft 365 on Windows, save the workbook to OneDrive or SharePoint, then select Share in the upper-right corner and choose who can access it. You need to be signed in to an account with permission to use that cloud location. Sharing this way lets people open the same file, and—when editing is allowed—work on it together.

What You’ll Need

  • Excel for Microsoft 365 and an internet connection.
  • A Microsoft account, or a work or school account, signed in to Excel.
  • A workbook saved in OneDrive or a SharePoint document library. A file stored only on your computer cannot use Excel’s current co-authoring share link.
  • Permission to share from that OneDrive or SharePoint location. In a workplace, your Microsoft 365 administrator may restrict external sharing or link types.

Step-by-Step

  1. Open the workbook and sign in. Start Excel and open the file you want to share. Look near the top-right of the Excel window for your account name or profile icon. If Excel asks you to sign in, use the account that has access to the OneDrive or SharePoint location where the workbook should live. A personal Microsoft account and a work or school account are not interchangeable for every organization’s files, so use the account your collaborators expect.
  2. Save the workbook to a cloud location. Select File > Save As, choose OneDrive or the appropriate SharePoint site, select a folder, enter a filename, and choose Save. If the workbook is already saved there, use File > Info to check its location, or look at the filename and status area in Excel. You can also use the Save button if Excel offers to save the current file to OneDrive. Do not just copy a link to a local file path; other people will not be able to reach a file that exists only on your computer.
  3. Check that the cloud save has completed. Wait for Excel to finish saving and resolve any sign-in or upload prompts. If AutoSave is available, its switch is usually near the upper-left; turn it on if you want changes saved automatically. AutoSave does not make a local workbook shareable by itself: the file still needs to be in OneDrive or SharePoint. If you have unsaved edits, save them before sending an invitation so recipients see the intended version.
  4. Open the sharing controls. Select Share at the upper-right of the Excel window. In some builds, the button may be represented by a person or link icon, or you may find the sharing command through File > Share. If Excel presents a prompt to upload or save the file to the cloud, follow it and then select Share again. A disabled button usually means the file, account, or organization is not currently eligible; see Troubleshooting below rather than enabling an unrelated legacy feature.
  5. Choose who can use the workbook. In the sharing dialog, enter the names or email addresses of the people you want to invite. Depending on your Excel version and organization, you may instead be able to select a link option such as Copy Link. Open the permission or link-settings control before sending. Choose whether the people can edit or only view, and check whether the link is limited to named people, people in your organization, or anyone with the link. Available choices depend on your account and administrator policies.
  6. Set the access level deliberately. Leave editing enabled only when collaborators should change cells, formulas, or formatting. For review-only access, select a view permission if offered. A link that works for anyone who receives it is easier to forward, but it is less restricted than an invitation to specified people. If the dialog offers an expiration date or password for the link, use those options when appropriate and available. Avoid putting confidential information in a broadly accessible workbook or link.
  7. Send the invitation or copy the link. Add a short message if useful, then select Send to email invitations through Microsoft 365. If you chose Copy Link, copy the generated link and share it through an approved channel. A copied link is not necessarily public: its permissions follow the settings you selected. Tell recipients whether they can edit and which account they should use, especially when access is restricted to named people or your organization.
  8. Confirm access and continue collaborating. Return to the workbook and use the sharing controls to review or manage access if needed. You can usually see collaborators’ initials or profile pictures while they have the file open. Ask a recipient to open the link and confirm they can see the workbook; if they need to make changes, verify that they received edit permission and signed in with the authorized account. Excel’s desktop app, Excel for the web, and supported mobile apps can all open shared workbooks, although some features differ by platform.

Mac and web differences: In Excel for Mac, sign in and save the workbook to OneDrive or SharePoint, then use the Share button, generally at the upper-right; the sharing dialog may be arranged differently from Windows. In Excel for the web, open the cloud-stored workbook in a browser and select Share near the upper-right. The essential requirements are the same: a supported cloud location, an authorized account, and permissions that allow the intended recipients to access the file.

Common Mistakes

  • Trying to share a file that is only on the PC. The Share button may prompt you to upload it, or the sharing action may not be available. Save a copy to OneDrive or SharePoint first, then share that cloud copy. If you keep a separate local copy, remember that edits to it will not automatically appear in the shared version.
  • Confusing the modern Share command with Shared Workbook (Legacy). The old Shared Workbook feature is a separate, older collaboration method and is not how current Microsoft 365 co-authoring is normally enabled. You generally do not need to add that command to the ribbon to share a workbook. Use the Share button and cloud storage instead.
  • Choosing the wrong permission. A viewer cannot edit cells, while an editor may change the workbook. Check the setting before sending, and do not assume that everyone with a link can edit—or that every link is restricted to its intended recipient.
  • Sending the link to an address different from the signed-in account. A recipient can get an access-denied message if the file is restricted to a particular email address but they open it under another Microsoft account. Invite the right address or have the recipient switch accounts.
  • Expecting an emailed attachment to stay synchronized. If you download or attach a copy, edits to that copy do not update the shared cloud workbook. Share the OneDrive or SharePoint link when everyone should work on the same file.

Tips

  • Use named-person access for sensitive files. A link limited to specified people is easier to control than a link that can be forwarded freely. Review the sharing dialog carefully because organization settings may change which link types appear.
  • Keep the workbook in a shared team location when appropriate. For ongoing team work, a SharePoint library or a team’s OneDrive location can be more dependable than one person’s desktop folder. Confirm that collaborators have access to the site or folder as well as to the workbook.
  • Give recipients a useful instruction. Include the workbook name, whether they should edit or review, and the account they should use. This avoids confusion when they have multiple Microsoft accounts.
  • Review access after a project ends. Use the workbook’s sharing controls or the file’s OneDrive or SharePoint access-management options to remove people or change permissions. Removing an invitation does not remove copies someone may already have downloaded.
  • Be cautious with simultaneous structural changes. Co-authoring is useful for entering and reviewing data, but coordinate major changes such as deleting sheets, moving columns, or changing workbook structure. Some features or file types may not behave identically for every collaborator or Excel platform.

Troubleshooting

  • The Share button is missing or grayed out: Confirm that the workbook is saved to OneDrive or SharePoint, that Excel is signed in, and that you have an internet connection. Save the workbook, close and reopen it if necessary, and check whether the file opens from the expected cloud location. If it is a local file, use File > Save As to save a cloud copy. If the control remains unavailable for a work account, ask your Microsoft 365 administrator whether sharing is restricted.
  • Excel says the file must be uploaded or saved online: Follow the prompt to choose a OneDrive or SharePoint folder, then wait for the upload to finish. If the prompt fails, check your connection and available cloud storage, and make sure you are signed in to the correct account. You can also save through File > Save As and reopen the saved cloud version.
  • A collaborator sees an access request or permission error: Check which email address you invited and which account the recipient used to open the link. If appropriate, grant access to the correct address or create a new link with the suitable audience and permission. In a company or school, the administrator may block external users, anonymous links, or sharing outside the organization; ask the administrator rather than trying to bypass the policy.
  • The recipient can open the workbook but cannot edit: Reopen the sharing settings and verify that the invitation or link allows editing. Also check whether the workbook or its location has restrictions, and ask the recipient to open the original cloud link rather than a downloaded copy. If editing is intentionally disabled, provide a separate editable copy only if that is safe and suitable.
  • Changes are not appearing for everyone: Check that all collaborators opened the same OneDrive or SharePoint file, not separate attachments or downloaded copies. Look for save, sync, or sign-in warnings in Excel and make sure each person is online. If someone’s changes are still pending, have them save and allow synchronization to finish before closing the workbook.

Frequently Asked Questions

Why is the Share option disabled in Excel?
Most often, the workbook is saved only on your computer, Excel is not signed in, or your organization has restricted sharing. Save to OneDrive or SharePoint, sign in, and check with your administrator if the restriction remains.

Can I share an Excel workbook without OneDrive?
You can send a separate copy as an email attachment or store a file in another service, but that is not the same as Excel’s cloud co-authoring share link. For the built-in Microsoft 365 sharing experience, use OneDrive or SharePoint.

Can people edit a workbook after I share it?
Yes, if you grant edit permission and the recipient can access the file. If you select view-only access, they can read the workbook but cannot make changes to the shared original.

How do I share an Excel file with someone outside my organization?
Use the sharing dialog to invite their email or select an external link option if it is available. Your organization may block external sharing, so ask its Microsoft 365 administrator if the option is missing or the recipient cannot get access.

Do I need to turn on Shared Workbook (Legacy)?
No, not for the standard Microsoft 365 Share feature. Save the workbook to OneDrive or SharePoint and use Share. The legacy command is a separate older feature and is not a substitute for current cloud sharing.

Will Excel show who else is working in the file?
When collaborators open the same supported cloud workbook, Excel may show their initials or profile pictures and indicate where they are working. The exact indicators vary by platform and version, but everyone must open the shared cloud file for co-authoring.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.