How to Share an Excel Workbook in Windows 11 Safely

How-to basics · Updated November 20, 2026

To share an Excel workbook in Windows 11, save it to OneDrive or SharePoint, select Share in Excel, choose who can access it and whether they can edit, then send an invitation or copy a link. You will need an internet connection and a Microsoft account or work or school account with access to the cloud location. Sharing this way lets people open the same file and, when coauthoring is available, make changes together.

What You’ll Need

  • Excel for Microsoft 365 on Windows: The steps below use the desktop app. Excel for the web has similar sharing options, though some buttons may be in different places.
  • A OneDrive or SharePoint location: You can use personal OneDrive or a work or school SharePoint library. Your organization may restrict which locations and link types are available.
  • A Microsoft account or work or school account: You need to be signed in to save to the cloud and manage sharing. Recipients may need to sign in too, depending on the permission link you choose.
  • The recipients’ email addresses, if inviting specific people: Check that you have the right addresses and that the recipients can access the selected account or organization.

Step-by-Step

  1. Open the workbook and check its contents. Start Excel from the Windows 11 Start menu and open the workbook you intend to share. Confirm that it is the correct file and that it does not contain information you do not want recipients to see. Think about hidden worksheets, comments, and data on other tabs as well as the currently visible sheet. If the workbook contains sensitive information, share only with named people and avoid a broadly accessible link.
  2. Save a cloud copy. Select File > Save As. Choose OneDrive or a suitable SharePoint site or document library, then choose a folder and save the workbook. If you do not see the intended cloud location, select Add a Place or sign in to the correct Microsoft account when prompted. Saving to a cloud folder is important: attaching a local copy or emailing the file does not create one shared workbook that everyone edits together. Keep the standard Excel workbook format, such as .xlsx, unless your work requires a different format.
  3. Make sure the cloud save has completed. Give Excel time to finish saving, and check for any upload or sign-in warning near the top of the window. For a OneDrive or SharePoint file, the AutoSave switch may appear at the upper left. Turn it on if it is available and currently off. AutoSave is available for supported cloud files, not ordinary files saved only on your PC. If a dialog asks whether to use the cloud version or a local version, confirm that you are working with the copy you mean to share.
  4. Open the sharing controls. Select the Share button, usually near the upper-right corner of Excel. If Excel asks you to save the workbook first, do so. In the sharing window, you can usually enter names or email addresses to invite people, or open the link settings to create a link. The choices displayed depend on whether the file is in personal OneDrive or a work or school location and on any policies set by your organization.
  5. Choose who can use the link. Before copying or sending a link, inspect its access setting. Options may include Anyone with the link, People in your organization, People with existing access, or Specific people. These options are not available in every account. For a private workbook, choose Specific people and enter the intended recipients. An anyone link can be forwarded, so use it only when that level of access is appropriate. A people-with-existing-access link does not grant access to someone new; it is useful for pointing current collaborators to the file.
  6. Set editing or viewing permission. In the link settings, check whether the permission says Can edit or Can view. Turn off editing if recipients should read the workbook without changing it. If you are inviting people by email, check the permission offered in the sharing dialog before sending. Some accounts provide additional controls, such as an expiration date or a password for a link; use them if available and appropriate. Select Apply if the dialog requires it to save your choices.
  7. Send an invitation or copy the link. To invite specific people, enter their email addresses, add an optional message explaining what they should do, and select Send. To distribute a link yourself, choose Copy link, then paste it into a message or another suitable channel. Before sending, confirm that the link has the access setting you intended. If the dialog offers a choice between sending an invitation and copying a link, remember that copying does not itself notify recipients.
  8. Ask a recipient to open the shared file. The recipient can select the invitation link and sign in if requested. They may open the workbook in Excel for the web or choose to open it in the desktop app. If Excel asks whether to open the file in the browser or application, either can work for ordinary editing, but the available tools can differ. Ask the recipient to confirm they are editing the cloud workbook, not a downloaded copy saved elsewhere.
  9. Work together and check that changes save. When coauthoring is supported, you and other editors can make changes in the same workbook, and Excel may show collaborators’ presence or selected cells. Avoid making conflicting edits to the same content at the same time. Confirm that AutoSave is on where available and that Excel shows no pending upload or connection warning. Recipients with view-only access will not be able to edit the shared file.
  10. Review or change access later. In Excel, select Share and look for Manage Access or the option to review access, depending on the version and account. You can change a person’s permission, remove their access, or delete a link. You can also manage the file from OneDrive or SharePoint. Removing one link may not remove access granted through another link or direct invitation, so review the listed people and links when tightening access.

Common Mistakes

  • Sharing a local file instead of the cloud workbook. A file stored only in Documents or on the desktop is not automatically set up for live coauthoring. Save it to OneDrive or SharePoint and share that cloud copy.
  • Choosing an overly broad link. Anyone links can be forwarded. Do not select one just because it is the fastest option if the workbook is intended for a small group. Use specific people or an organization-only option when available.
  • Leaving edit permission on by accident. A recipient with edit access can change workbook contents. Set view-only access for readers and review the permission label before sending.
  • Sharing the wrong copy. A workbook may exist in several folders with similar names. Check its location and confirm that collaborators are opening the cloud version rather than an old attachment or downloaded copy.
  • Expecting every file feature to work identically for everyone. Some workbook features, file types, or organizational controls can limit coauthoring or behave differently in Excel for the web. If collaboration is essential, test the shared file with a colleague before relying on it for a deadline.

Tips

  • Use specific people for confidential work. This ties access to the recipients you select rather than relying on a link that may be passed along. Recipients may need to verify their identity or use the invited account.
  • Give the file a clear name and location. A name that identifies the project and a shared team folder make it easier to distinguish the current workbook from older copies. Avoid names that disclose confidential details if the filename itself may be visible to others.
  • Agree on editing expectations. Tell collaborators which sheets or fields they should update and whether they should avoid sorting or rearranging shared data while others are working. Clear expectations reduce accidental changes.
  • Use version history as a recovery option. OneDrive and SharePoint commonly provide version history for stored files. If an unwanted edit is saved, check the file’s version history before trying to rebuild the workbook manually. Available history and restore controls can depend on your account or organization.
  • Keep a separate backup for important files. Cloud storage and version history are useful, but they are not a substitute for following your organization’s backup or records procedures. Make a separate copy before a major restructuring or handoff.

Troubleshooting

  • The Share button is missing or disabled: Confirm that you are signed in to Excel and connected to the internet. Save the file to OneDrive or SharePoint, then reopen the sharing controls. If you are using a work account, your administrator may have disabled sharing or the selected location may not support it.
  • The recipient sees an access denied message: Check that you shared with the correct email address and that the link is intended for that person or organization. If the invitation went to one account but the recipient is signed in with another, have them switch accounts. You can also use Manage Access to review the recipient’s permission and send a new invitation if needed.
  • The recipient can open but not edit: The link may be view-only, or the recipient may have opened a copy rather than the cloud file. Review the permission in the sharing settings. If editing is appropriate, change the access to Can edit and have them reopen the original shared link.
  • Changes are not appearing for other people: Check the connection and look for an upload or sync warning in Excel or OneDrive. Make sure each person is using the same cloud file and not separate downloaded copies. Wait for saving to complete, then close and reopen the shared workbook if the display remains stale. Do not create another copy as a workaround until you know which version contains the latest changes.
  • You cannot create an anyone link or other link type: The option may be unavailable because of your Microsoft account type, OneDrive settings, or a work or school sharing policy. Choose an allowed option, such as inviting specific people, or ask your organization’s Microsoft 365 administrator what sharing methods are permitted.
  • The workbook will not coauthor: Verify that it is saved in OneDrive or SharePoint and that everyone is opening the cloud copy. Older formats, unsupported workbook features, or an outdated Excel installation can interfere. Save a compatible .xlsx copy if suitable, update Office through your organization’s approved process, and try opening the file in Excel for the web. Keep an untouched copy before changing formats or removing features.

Frequently Asked Questions

Can I share an Excel workbook without OneDrive or SharePoint?
Yes, you can send a copy as an email attachment or use another file-sharing service, but that usually creates separate copies rather than one live coauthored workbook. To use Excel’s cloud sharing and coauthoring, store the file in OneDrive or SharePoint.

Can people edit the workbook at the same time?
Yes, if the workbook is stored in a supported OneDrive or SharePoint location, the participants have edit permission, and their Excel apps support coauthoring. They can also use Excel for the web. Availability can depend on the file’s features and account policies.

Do recipients need Excel installed?
No. They can often open a shared workbook in Excel for the web using a browser. Some features may work differently or be unavailable there. A recipient with the desktop app can choose to open the cloud file in Excel for Windows.

Can I share a workbook as view-only?
Yes. Set the link or invitation permission to Can view before sharing. Check the setting each time you create a link; a previous link or a separate invitation may have different permissions.

How do I stop sharing the workbook?
Open Share and review Manage Access, or manage access from OneDrive or SharePoint. Remove individual people or delete the link you no longer want to work. Review all access entries because deleting one link may not revoke other invitations or links.

Does sharing a workbook expose every worksheet?
Recipients who can open the workbook may be able to see its sheets, including hidden sheets, depending on their permissions and the workbook setup. Hiding a sheet is not a reliable security boundary. Remove information recipients should not access or create a separate, appropriately limited workbook before sharing.

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.