To share work in Excel for Microsoft 365 on Windows, save the workbook to OneDrive or SharePoint, select Share in the upper-right corner, choose who can access it and whether they can edit, then send an invitation or copy a link. When people open that cloud-stored workbook in a supported version of Excel, they can work in it together and see many changes appear as they are made.
What sharing in Excel means
Excel sharing gives other people access to a workbook file. It does not simply send a separate copy unless you choose to attach or download one. With a shared cloud workbook, you and your collaborators can usually work from the same file, rather than emailing versions back and forth and later trying to combine them.
Sharing is different from sharing a worksheet tab. Excel’s Share feature applies access to the workbook as a whole: it does not normally let you grant one person access to only one tab while hiding the other tabs. Hiding a sheet is not a reliable privacy measure, because someone with sufficient access may be able to unhide it or inspect workbook contents. If people should not see particular information, remove it from the file or create a separate workbook with only the information they are allowed to access.
There are two related ideas to keep straight:
- Access permission: whether a person can open the workbook and whether they can edit it.
- Co-authoring: multiple people making changes in the same cloud-hosted workbook, with their edits synchronized through Excel.
A person can be given view access without being allowed to change the source file. Edit access lets them change workbook content, although some controls may still be restricted by workbook protection or organizational policies.
How to share a workbook step by step
- Save the workbook online. In Excel, save it to OneDrive or a SharePoint document library. If it is currently stored only on your computer, use File > Save As and choose an available OneDrive or SharePoint location. Your organization may control which locations are available.
- Select Share. Use the Share button near the upper-right corner of the Excel window. If Excel prompts you to upload or save the file to a cloud location first, follow that prompt.
- Choose recipients or a link. You can enter the names or email addresses of specific people and send an invitation, or use the link option to copy a sharing link.
- Check the permission. Before sending, confirm whether recipients can edit or only view. Available link choices depend on your account, the storage location, and settings imposed by your organization.
- Send or copy the link. Send the invitation from the sharing dialog, or copy the link and deliver it through an appropriate channel. Recipients may need to sign in with an account that has permission.
The exact wording and arrangement of controls can vary slightly as Microsoft updates Microsoft 365. In Excel for the web, the Share control is also available in the workbook interface. In Excel for Mac, use the Share button as well; saving the workbook in OneDrive or SharePoint and selecting the right access level are still central to cloud collaboration. Excel for the web can be useful when a collaborator does not have the desktop app available, though some desktop features may differ.
Choosing between editing, viewing, and link access
Choose the narrowest access that lets someone do their task. Give edit access to people who need to enter data, update formulas, or maintain the workbook. Give view access when someone only needs to read or review it. Depending on the sharing dialog and your organization, you may also see options to restrict a link to named people, people in your organization, or anyone who receives the link.
A link is convenient, but it is not automatically private just because it was sent by email. A link set for broad access may be forwarded. A link restricted to specific people or an organization usually offers more control, but recipients may have to authenticate. Work or school administrators can disable link types or impose other rules, so an option that appears in one account may be unavailable in another.
Before sending, check the link settings rather than assuming the default is appropriate. If the dialog offers an expiration date or password option, use it only if it suits your organization’s policy and your recipients’ needs; such controls are not available for every account or link type. You can also share directly with named people instead of creating a broadly usable link.
When access needs change, return to the workbook’s sharing controls or manage permissions in OneDrive or SharePoint. You can often stop sharing, remove an individual, or change a link’s permissions. Revoking access prevents future access through that permission, but it cannot retrieve a copy someone already downloaded, copied, photographed, or otherwise retained.
What collaborators can do in a shared workbook
When co-authoring is available, collaborators can make edits in the same workbook, and Excel displays other editors’ presence or activity in supported versions. Changes generally synchronize through the cloud, but a brief delay can occur. A collaborator’s selection or cursor may be visible, which helps explain why a cell is being changed while another person is working.
Co-authoring is not the same as a live meeting or a guarantee that every feature behaves identically for every editor. A user may open the workbook in desktop Excel, Excel for the web, or a mobile app, and the available tools can differ. For discussion about a particular value, use comments where available or agree on a separate communication channel. Comments are useful for context, but they do not replace editing permissions.
AutoSave is commonly available for files saved in OneDrive or SharePoint in Microsoft 365. Check that the workbook is saved to the intended cloud location and that AutoSave is on if you expect edits to synchronize automatically. If it is off, or a collaborator is offline, changes may not reach others until the file is saved or the connection is restored.
Prepare the workbook before inviting people
A little preparation can prevent accidental edits and make a shared workbook easier to use. Decide which people need editing rights, and make the intended input areas obvious. For example, a team entering monthly expenses might use one designated input table, with separate columns for date, category, description, and amount, rather than letting everyone add data anywhere on the sheet.
- Give worksheets and tables clear names, and label input columns so collaborators know what to enter.
- Use data validation or formatting where it helps prevent inconsistent entries, such as dates entered in different formats.
- Identify formula cells and explain whether collaborators should leave them unchanged.
- Remove unnecessary personal, confidential, or historical information before sharing.
- Keep a backup or use the file’s version history where available, especially before a major collaborative update.
Worksheet protection can help prevent accidental changes to selected cells, but it is not a substitute for access control or a way to make sensitive data secret. A workbook owner should test the workflow with the actual users and permissions. For a recurring process, document who enters data, who reviews it, and how corrections should be made so that edits do not silently overwrite an expected value.
Common sharing problems and how to fix them
The Share button is missing or the file cannot be shared. Confirm that you are signed in to the account that owns or can edit the file. A workbook saved only on a local drive is not set up for cloud co-authoring; save it to OneDrive or SharePoint first. A company or school administrator may also restrict sharing.
A recipient gets an access-denied message. Check that you shared with the correct email address and that the recipient signed in with that account. If you sent a link restricted to your organization, an outside recipient may not be able to open it. Change the access setting only if doing so complies with your data rules.
People keep creating separate copies. Make sure collaborators open the shared cloud link rather than downloading the workbook and working on a local copy. Ask them to verify the file name and location in Excel. Separate downloaded copies do not automatically merge their changes back into the original workbook.
Edits are not appearing. Check the internet connection, the file’s cloud location, and AutoSave status. Ask collaborators to make sure they are editing the shared file rather than a similarly named copy. Some older file formats or workbook features may limit co-authoring; saving a compatible copy in a modern Excel format can help, but do so carefully and retain a backup if conversion could affect features.
Someone changed or deleted important content. Check whether version history is available for the file in OneDrive or SharePoint, then review an earlier version before restoring anything. Restoring an older version can replace later changes, so coordinate with other editors first. For important workbooks, agree on a backup and review process before a problem occurs.
Excel sharing versus email attachments and legacy sharing
Emailing an attachment is still useful when the recipient needs a snapshot, must work offline, or should receive a separate copy. However, each attachment can become a different version. If several people edit separate copies, someone must reconcile those changes manually. A cloud link is generally better when the goal is one current workbook that authorized people can update.
Excel also has an older feature commonly called Shared Workbook (Legacy). It is distinct from modern cloud co-authoring and has limitations; in current Excel it may not be shown on the ribbon by default. For ongoing collaboration, Microsoft’s OneDrive or SharePoint sharing and co-authoring approach is generally the more suitable option. Do not confuse the legacy feature with the Share button: the modern Share workflow manages cloud access and supports collaboration through the Microsoft 365 environment.
Neither approach removes the need for a clear owner. Decide who can change formulas, who checks data quality, and how to handle conflicting edits. For a simple list, several editors may work well in one workbook. For a controlled process with approvals, audit requirements, or sensitive records, a spreadsheet may not provide all the workflow and access controls required; use an approved organizational system if policy calls for one.
Privacy and safe sharing practices
Treat a shared workbook as information you are deliberately making available to the people named or covered by its link. Review every sheet, including hidden sheets, and check for old data, comments, and identifying details that are not needed by recipients. A workbook can contain more information than is visible in the current tab, so inspect the file rather than relying only on what appears on screen.
Use named-person or organization-restricted access for confidential work when those options are available and appropriate. Avoid placing a broadly accessible link in a public post or a channel where unintended people can obtain it. If a link is sent to the wrong audience, use the sharing controls to revoke or narrow it promptly, then notify the appropriate owner or administrator if the information is sensitive.
Access permissions reduce the chance of unauthorized opening, but they cannot prevent an authorized editor from copying information. They also do not make a workbook immune to mistakes or malicious changes. Limit edit access, keep recovery options such as version history in mind, and follow your organization’s retention and security rules.
Frequently Asked Questions
Can two people edit the same Excel file at the same time?
Yes, if the workbook is stored in OneDrive or SharePoint and opened in a version of Excel that supports co-authoring. Both people need suitable access, and changes synchronize through the cloud. Older formats, unsupported features, or organization settings can affect whether co-authoring is available.
Do people need Microsoft 365 to edit a shared Excel workbook?
Not necessarily. A recipient may be able to use Excel for the web or another supported Excel app, depending on the file and account permissions. The tools available can vary by app, and some desktop capabilities may not be present in the browser.
How do I share an Excel file so people can only view it?
Select Share, choose the recipients or link settings, and select a view-only permission if it is offered. Confirm the setting before sending. A viewer should not be able to edit the shared source workbook, but can potentially make a separate copy if their account and the sharing options allow it.
Can I share just one worksheet in Excel?
The normal Share feature grants access to the workbook, not just an individual worksheet. Hiding or protecting other sheets does not create dependable confidentiality. Make a separate workbook containing only the content the recipient should see.
Can I stop sharing a workbook later?
Usually, yes. Use the workbook’s sharing controls or its OneDrive or SharePoint permissions to remove a person, change access, or disable a link when those controls are available. This affects future access through that permission, not copies already saved by a recipient.
Related
- FIND in Excel: Syntax, Examples, and Common Errors
- Find the Max Date in Excel With Multiple Criteria Easily
- Find Max Value in Excel With Criteria Using MAXIFS
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Data Validation in Excel Without Deleting DataTo clear data validation in Excel for Microsoft 365 on Windows, select the cell or range, choose Data…
- Power Query for Data Lakes: What It Can and Can’t DoYes—Power Query in Excel for Microsoft 365 can connect to some data-lake storage, notably Azure Data Lake Storage…
- Excel Undo Shortcut: Keys, Limits, and How It WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action. On a Mac,…
- Scatter Plot Different Colors in Excel: A Clear GuideYes. In Excel, the reliable way to show different colors for different groups in a scatter plot is…
- Automatically Remove Duplicates in Excel: Methods and RisksYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Remove Duplicates to…
- How to Create Rules in New OutlookTo create a rule in New Outlook, select Settings (the gear icon) > Mail > Rules > Add…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.