Excel Share Workbook Not Working? Fix Sharing Issues

Errors & fixes · Updated November 19, 2026

If Excel’s sharing is not working, save the workbook to OneDrive or SharePoint, make sure you are signed in, and grant the other person permission through the Share button. Excel’s current coauthoring feature requires a supported cloud location and compatible access; the older “Shared Workbook” command is a separate, limited legacy feature.

How Excel workbook sharing works now

In Microsoft 365, several people can edit one workbook at the same time using coauthoring. The file is stored in OneDrive or SharePoint Online, and Excel synchronizes changes as collaborators work. Sending a copy as an email attachment, or saving the file only to a computer or ordinary network folder, does not provide this live shared editing experience.

To start sharing in Excel for Microsoft 365 on Windows, open the workbook and select Share near the upper-right corner. If Excel asks, save the file to OneDrive or SharePoint. Enter collaborators’ email addresses, choose whether they can edit or only view, and send the invitation. Depending on your organization’s settings, you may also be able to copy a link and share it separately.

Recipients must open the shared cloud file, not an older downloaded copy. When coauthoring is available, you can generally see other editors’ presence and changes appear as they are saved. Excel for the web can be a useful alternative when a desktop app is outdated or unavailable, although some workbook features may work differently in a browser.

Check these basics first

Before investigating complex causes, confirm that the workbook is in the right place and that the recipient has the right link and permission. These checks resolve many apparent sharing failures:

  • Confirm the file location. Look in OneDrive or a SharePoint document library. A file on your desktop, a USB drive, or a local network share is not a cloud coauthoring file.
  • Check your account. In Excel, confirm that you are signed in to the Microsoft account or work or school account that can access the storage location.
  • Test the link. Open it in a browser while signed in as the intended recipient, or ask that person to do so. A link may be restricted to people in your organization or to named recipients.
  • Check permissions. In Excel, select Share and look for Manage Access or the sharing settings shown for the file. Verify that the person has edit access if they need to change cells.
  • Confirm the recipient opened the current file. Make sure they did not open a downloaded attachment or an older copy with a similar name.

On a Mac, the Share control and cloud-account prompts may be arranged differently, but the same essentials apply: store the file in OneDrive or SharePoint, sign in, and share the cloud file with the correct permission. Excel for the web uses its browser sharing controls.

Why the Share button is missing or unavailable

If Share is absent, disabled, or does not offer a usable link, first check whether the workbook is saved locally. Excel may show sharing options only after the file is saved to an eligible cloud location. Use File > Save As to save a copy to OneDrive or a SharePoint location you can access, then try Share again.

Also check whether you are signed in and whether your organization allows external sharing. A company or school administrator can restrict who may create links, share with people outside the organization, or edit files. In that case, changing an Excel setting will not override the organization’s policy; ask the SharePoint or Microsoft 365 administrator to confirm the permitted options.

Some workbook protections or file encryption can interfere with editing or coauthoring. For example, a password required to open an encrypted file is different from a sheet-protection password and may prevent cloud collaboration from working as expected. Do not remove protection from sensitive material simply to make sharing work. Ask the file owner or administrator whether the protection is intentional and what approved sharing method to use.

When collaborators cannot edit together

A person may be able to open a workbook but still be unable to edit it. The most common cause is that the link grants view access, or that the recipient is signed in with an account different from the one invited. Have the owner review access settings and, if appropriate, grant edit permission to the correct address. If the link is organization-only, an outside recipient may need a different approved arrangement.

Coauthoring can also fail when someone opens a copy in an older Excel release or through a workflow that does not support the current cloud collaboration features. Ask everyone to update Microsoft 365, sign in, and open the file directly from its OneDrive or SharePoint location. If a desktop app continues to show a read-only or locked message, try opening the same link in Excel for the web. That helps distinguish an app-specific problem from a permission or storage problem.

Network interruptions can delay updates, and a person working offline may not see new edits immediately. Reconnect to the internet and allow Excel to synchronize before closing or switching to another copy. If the workbook displays a conflict or asks which version to keep, compare the versions carefully rather than assuming one is automatically complete. Avoid having collaborators make separate offline copies and later overwrite the shared file; that can lose changes.

File types, features, and AutoSave

For ordinary coauthoring, use a modern Excel workbook format such as .xlsx. Macro-enabled workbooks may also be shared, but macros do not become a shared live process: each person’s Excel runs macros in their own session, and macros can affect what collaborators experience. Follow your organization’s security rules before enabling macros in a shared file.

Some features, protection settings, or content may limit editing or behave differently across Excel for Windows, Mac, and the web. If only one participant has trouble, check whether they are using an unsupported feature or a different app version. If the whole group is blocked, focus first on permissions, cloud storage, sign-in, and organizational policy rather than converting the file immediately.

AutoSave is associated with files stored in OneDrive or SharePoint and can save changes continuously when available. It is not a substitute for a working internet connection or correct access, and it may be unavailable for a local file. Check the AutoSave control and Excel’s status messages, but do not treat an off switch by itself as proof that sharing is broken; investigate the file location and synchronization status as well.

Current coauthoring versus Shared Workbook (Legacy)

The wording causes confusion because Excel has an older feature called Shared Workbook (Legacy). It was designed for a different style of collaboration, often involving a workbook on a network location, and it has substantial feature limitations. It is not the same as today’s cloud-based coauthoring, and enabling it is usually not the right fix when the Share button fails.

In Excel for Microsoft 365 on Windows, the legacy command may be hidden. If you specifically need it for an existing workflow, you can add it through File > Options > Quick Access Toolbar, choose All Commands in the command list, select Share Workbook (Legacy), and add it. The command’s availability and placement can vary by Excel version. Before using it, check whether the workbook depends on features that the legacy mode restricts and whether your team actually needs that older workflow.

For most teams, the practical choice is straightforward: use the Share button and cloud coauthoring for simultaneous editing; use the legacy feature only when a specific existing process requires it. A network folder containing a workbook does not automatically become a modern coauthoring location just because several people can see the folder.

A careful troubleshooting sequence

Use this order to narrow down the problem without making unnecessary copies or weakening security:

  1. Save a copy to the appropriate OneDrive or SharePoint location, if the workbook is currently local.
  2. Sign in to Excel with the account that owns or can edit the file.
  3. Select Share, set the intended view or edit permission, and send a fresh invitation or link.
  4. Ask the recipient to sign in with the invited account and open the link directly, preferably in Excel for the web as a comparison.
  5. Update Excel and check for organization policies, file encryption, or protection that may restrict access.
  6. Wait for synchronization to finish before closing the file, and resolve any version conflict by reviewing the actual edits.

If the problem remains, note the exact error message, where the file is stored, which account each person uses, and whether the issue affects one or all collaborators. Those details help an administrator distinguish a permissions policy from an Excel client or sync issue. Avoid emailing multiple renamed copies as a workaround unless you have a clear plan to reconcile them.

Frequently Asked Questions

Why can’t I share an Excel workbook from my computer?
Current coauthoring relies on an eligible cloud-stored file, typically in OneDrive or SharePoint Online. Save it there, sign in, and use Share. A local file can be sent as a copy, but that does not enable live shared editing.

Why can someone open my workbook but not edit it?
The link may grant view-only access, or the person may be signed in with a different account from the one invited. Check Manage Access or the sharing settings, then confirm the recipient opens the link using the correct account.

Can I share an Excel workbook without OneDrive?
You can send a copy or use another storage and collaboration service supported by your organization, but that is not necessarily Microsoft 365 coauthoring. For Excel’s current built-in shared editing, use an eligible OneDrive or SharePoint location. Ask your administrator which services are approved.

Is Shared Workbook (Legacy) the same as the Share button?
No. The Share button is for modern cloud sharing and coauthoring. Shared Workbook (Legacy) is an older feature with different behavior and limitations; it generally should not be enabled as a workaround for cloud-sharing problems.

Why are collaborators not seeing my latest changes?
Check that everyone opened the same cloud file, is online, and has completed synchronization. A downloaded copy, offline edits, or a version conflict can leave someone viewing changes that have not reached the shared workbook yet.

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.