Excel Share Not Working? Fix Sharing and Coauthoring

Errors & fixes · Updated November 19, 2026

If Excel’s Share button is missing, greyed out, or not giving someone access, first save the workbook to OneDrive or SharePoint, sign in to Microsoft 365, and check the recipient’s permissions. For live coauthoring, everyone should open the same cloud-stored file in a supported, up-to-date version of Excel or Excel for the web—not separate copies downloaded to their computers.

What Excel sharing does

Excel sharing covers two related tasks: granting someone access to a workbook and letting multiple people work in that workbook. The Share button creates an invitation or link with permissions such as viewing or editing. When the file is stored in OneDrive or SharePoint and the participants use compatible versions, changes can appear for other editors while they work. That live collaboration is called coauthoring.

Sending a workbook as an email attachment is different. Each recipient may end up editing an independent copy, so their changes do not automatically combine with yours. Likewise, a link to a file on a local desktop or an ordinary network folder does not turn it into a cloud-coauthored workbook. If the goal is simultaneous editing, share the cloud file itself rather than a copy.

Sharing options can also depend on the account. A personal Microsoft account, a work or school account, and an organization-managed SharePoint site may offer different link choices. An administrator can restrict external sharing or links that work for anyone, so a missing option does not necessarily mean Excel is malfunctioning.

Check the workbook location and file type

In Excel for Microsoft 365 on Windows, look at the workbook name or use File > Save As to see where the file is saved. For collaboration, save it to OneDrive or a SharePoint document library that you can access. If it is currently on your PC, choose a cloud location, save it there, and share that saved version. Avoid leaving one person in a local copy while others use the cloud copy.

Use a modern workbook format, such as .xlsx, unless the workbook needs macros, in which case .xlsm may be appropriate. Older formats and workbooks using legacy shared-workbook features can behave differently and may not support modern coauthoring. If Excel displays a compatibility warning or says a feature prevents coauthoring, follow the message and consider saving a compatible copy for collaboration. Keep the original if conversion could affect features or macros.

In Excel for the web, open the workbook from OneDrive or SharePoint and use Share near the top of the page. The web app is a useful diagnostic: if collaborators can edit there but not in the desktop app, the issue may be the desktop sign-in, update level, or local connection rather than the link itself.

Share the workbook with the right permission

  1. Open the cloud-stored workbook in Excel and select Share, usually at the upper right.
  2. Enter the person’s email address, or open the link settings to choose who can use the link if your account permits that option.
  3. Choose whether recipients can edit or only view. Check the setting before sending; a valid link with view-only access will not let someone change cells.
  4. Select Send or Copy Link, depending on how you want to deliver access. If you copy a link, send it through the channel your recipient can reach.
  5. Ask the recipient to open the link while signed in with the account that has permission. If prompted, have them request access rather than making another copy.

For an existing share, select Share and look for Manage Access or the access details for the workbook. There you can review people and links, change or remove permissions where available, and create a fresh link if the old one has been deleted or restricted. The exact controls can vary with the account and organization.

Common reasons the Share button does not work

  • The file is not in a cloud location: A workbook saved only to the PC may not offer the same sharing workflow. Save it to OneDrive or SharePoint first.
  • You are not signed in: Excel may be open, but the Office account needed to access the storage location is not connected. Check the account shown in Excel and sign in with the account that owns or can edit the file.
  • You have view access, not ownership or edit rights: A recipient generally cannot grant other people access unless the owner or site permissions allow it. Ask the owner to share the workbook or adjust your access.
  • The organization blocks the requested sharing method: Work and school administrators can limit external recipients, anonymous links, or particular cloud services. Ask the Microsoft 365 or SharePoint administrator which option is permitted.
  • The workbook is protected or uses an incompatible feature: Sheet protection is different from file-sharing permission, but it can prevent editing particular cells. Legacy sharing or compatibility issues can also interfere with coauthoring. Read any banner or error message before changing workbook settings.
  • The link is being opened with the wrong account: A personal account may not have access to a work file, or a recipient may be signed into a different organization account. Try the link in a browser profile signed in to the intended account.

When recipients can open the file but cannot edit

First distinguish a permission problem from a workbook-level restriction. If the recipient can view the workbook but cannot type anywhere, check whether the link was created as view-only and whether the person’s access is listed as Can view rather than Can edit. The owner can review the share settings and issue an editing invitation if appropriate.

If only certain cells are unavailable, the workbook may have protected sheets or locked cells. The owner can inspect the Review tab for protection controls, but should not remove protection without understanding why it was applied. Some workbooks intentionally lock formulas or input areas to reduce accidental changes. A user who has edit access can still be unable to change protected cells.

Also check whether the person opened a downloaded attachment instead of the shared cloud file. The workbook title or Excel’s save status can help identify this. Have them return to the original link and open the file there. Creating a new copy may be useful for independent work, but it does not grant editing rights to the source workbook.

Fix coauthoring, sync, and save conflicts

If everyone has access but their changes do not appear, make sure all editors are working in the same OneDrive or SharePoint file. A filename that looks identical does not prove it is the same file; separate downloads can have the same name. Ask everyone to reopen the shared link and confirm that Excel shows the cloud workbook rather than a local copy.

Check that the workbook is saving and that Excel is connected. In Microsoft 365 for Windows, the AutoSave switch may be available near the top of the window for eligible cloud files. Turning it on is useful for keeping cloud changes up to date, but it does not fix a broken connection or grant access. Look for a saving, saved, or error status, and resolve any sign-in or upload prompt before closing the workbook.

When edits conflict, Excel may show a conflict message or ask which changes to keep. Read the choices carefully rather than closing the warning without review. For important work, agree on who edits which areas, or have users pause while one person resolves the conflict. Avoid repeatedly editing offline and reconnecting without checking whether pending changes have uploaded.

If a recent edit appears lost, check the workbook in OneDrive or SharePoint online and, where available, review its version history. Restore or copy an earlier version only after confirming it contains the needed content; restoring can replace the current state. For critical workbooks, make a separate backup before major recovery steps.

Try the web app, updates, and connection checks

Open the shared link in Excel for the web as a comparison. If it works there, update and restart the Microsoft 365 desktop apps, confirm the correct account is signed in, and reopen the file from its OneDrive or SharePoint location. If the web app also fails, the problem is more likely related to permissions, the service, or the link itself than to one desktop installation.

Check whether OneDrive has paused syncing or is showing an upload error, especially if the workbook is in a synced folder. Confirm that the device is online and that the organization’s network or security controls are not blocking Microsoft 365 services. If other cloud files also fail to open or save, contact your IT administrator or check your organization’s service status rather than repeatedly resending the same link.

On a Mac, the same core requirements apply: use a current Excel version, sign in to the right Microsoft account, and store the workbook on OneDrive or SharePoint. Ribbon placement and account controls can differ from Windows, so use the Share control in the Mac app or Excel for the web. The browser version also works on supported Mac browsers, though some workbook features differ from desktop Excel.

Sharing safely and choosing the right link

Use the narrowest permission that suits the task. View access is sensible for people who only need to read a report; edit access is needed for collaborators who must change it. A link restricted to named people is generally more controlled than a link available to anyone who receives it, but your organization may not offer every link type. Avoid forwarding a broadly accessible link beyond its intended audience.

Before sharing, check whether the workbook contains personal, confidential, or commercially sensitive information, including hidden sheets or data that is not obvious in the visible worksheet. Sharing permission controls access to the workbook, not just the currently selected sheet. If access should end later, review Manage Access and remove the person or link where your account permits it. For work files, follow the organization’s data-handling rules.

Alternatives when live sharing is unavailable

If policy or technical limits prevent coauthoring, choose a method that matches the work. For read-only distribution, send a PDF or a view-only link. For separate contributions, ask collaborators to fill in separate files or clearly assigned sections, then have an owner combine the results. This avoids pretending that several independent copies will merge automatically.

For a one-time handoff, an email attachment can work, but label the authoritative copy and agree who is responsible for merging later edits. If the file contains macros or specialized features, test a collaboration copy before changing formats. Do not move sensitive workbooks to an unapproved consumer cloud service just to bypass an organization’s sharing controls; ask the administrator for an approved workflow instead.

Frequently Asked Questions

Why is Excel’s Share button greyed out? The workbook may be stored locally, you may not be signed in, or your account may lack permission to share it. Save a suitable copy to OneDrive or SharePoint, sign in with the correct account, and ask the owner or administrator if the control remains unavailable.

Can I share an Excel file without OneDrive? You can send a copy through another permitted method, such as an email attachment, but that is not the same as live cloud coauthoring. For Microsoft 365’s standard sharing workflow and collaborative editing, use OneDrive or SharePoint.

Why can someone open my Excel link but not edit? The link may grant viewing only, or the recipient may have opened the workbook with an account that has limited access. Check Manage Access and the link’s permission setting. If only some cells are blocked, sheet protection may be involved.

Do both people need Excel installed to edit together? No. A collaborator can use Excel for the web with an appropriate account and permission. Some features work differently or are unavailable in the browser, so desktop Excel may be needed for particular workbook tasks.

Why are my collaborator’s changes not showing? The two of you may be editing different copies, or one version may have unsaved or unsynced changes. Reopen the original shared link, check the save or sync status, and resolve any conflict prompt before continuing.

Can I share a workbook with someone outside my organization? Sometimes, but external sharing depends on the file location, account settings, and organization policy. If Excel does not offer an external link or the recipient is blocked, the owner should ask the administrator about an approved way to share it.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.