Excel Share Button Not Working? Practical Fixes to Try

Errors & fixes · Updated November 19, 2026

If Excel’s Share button is missing, disabled, or fails to send a link, first make sure the workbook is saved to OneDrive or SharePoint and that Excel is signed in to an account with permission to share it. The button is for sharing a cloud-stored file; a workbook saved only on your computer generally needs to be uploaded or moved to cloud storage before you can share it from Excel.

Why Excel sharing depends on cloud storage

In Microsoft 365 for Windows, Share appears near the upper-right corner of Excel. It creates or sends a link to a workbook stored in OneDrive or a SharePoint library. The people receiving the link access that cloud file, rather than a separate attachment that becomes disconnected from the original. Depending on the access you grant, they may be able to view or edit the same workbook.

This is different from attaching a workbook to an email. An attachment creates a separate copy, so changes made by one recipient do not automatically appear in the other copies. Sharing a cloud workbook can support simultaneous editing, but the available options depend on where the file is stored, the recipient’s access, and any organization policies.

Excel may still let you work on a local workbook even when its Share command cannot create a cloud link. That is why a working internet connection alone does not necessarily fix the problem: the file’s location and your account permissions matter too.

Check the file and account first

Before changing settings, identify what is actually failing. Is Share absent, greyed out, or clickable but unable to complete? Does the problem affect one workbook or every workbook? These details help separate a file-location problem from a sign-in, permission, or service issue.

  • Look at the file location. A path such as Documents or Desktop on your PC indicates a local file. A OneDrive or SharePoint location indicates cloud storage.
  • Check your Office account. In Windows Excel, open File > Account and confirm that the expected work, school, or personal Microsoft account is signed in.
  • Check whether the workbook is read-only. A read-only copy or a workbook opened in Protected View can limit what you can do. Do not enable editing unless you trust the file and its source.
  • Try a different workbook. If Share works for another file in the same account, the first workbook’s location, ownership, or permissions are likely relevant.

If Excel displays a specific error, note its wording before closing the message. A prompt saying you lack permission points to a different fix than one saying the upload or connection failed.

Restore sign-in and connection

Excel needs an active connection to the Microsoft account or organization that owns the cloud file. If Office is signed out, signed in with the wrong account, or unable to reach the service, Share may not work as expected. In Windows, go to File > Account and check the account shown there. If it is not the account that has access to the file, switch to the correct one.

For a sign-in problem, save any open work, close and reopen Excel, then sign in when prompted. If the account appears connected but access still fails, signing out and back in may refresh the session; be sure you know which account and credentials you need before doing so. A work or school account can also be blocked by an expired password, a required organization sign-in step, or an account that has not been granted access to the relevant OneDrive or SharePoint site.

Confirm that your internet connection works and that OneDrive is signed in and syncing if you use its desktop app. A paused or failed sync can leave a local copy out of date or prevent changes from reaching the cloud. If other Microsoft 365 services are also unavailable, the issue may be temporary rather than a setting in the workbook; try again later or check your organization’s service-status information.

Save the workbook to OneDrive or SharePoint

If the workbook is stored only on your PC, save a copy to a cloud location that you are allowed to use. In Excel for Microsoft 365 on Windows, choose File > Save As, select a OneDrive location or a SharePoint location available to you, and save the workbook there. The exact location names depend on your accounts and organization. Once the cloud copy is saved and accessible, use Share on that copy.

Check the name and location carefully after saving. A local original and a cloud copy can have the same filename, which makes it easy to keep editing the wrong one. Reopen the cloud copy from its OneDrive or SharePoint location, or use Excel’s recent files list and verify the file location before sharing. If you need to preserve the local original, saving a separate cloud copy avoids replacing it.

In Excel for the web, files opened from OneDrive or SharePoint are already in cloud storage and save changes there automatically. In Excel for Mac, the principle is the same, though the Save As dialog and available location choices may look different. Choose an available OneDrive or SharePoint destination, then share the saved cloud file.

Check ownership and link permissions

A file can be in the cloud without your account having the right to share it. For example, a workbook in a team SharePoint library may be controlled by the site owner, and an organization can restrict members from creating sharing links. If Share opens but you cannot set a link or add recipients, ask the file owner or your Microsoft 365 administrator whether your account is allowed to share that location.

In the sharing dialog, inspect the link settings before sending anything. Depending on the file and organization, you may be able to choose specific people, people in your organization, or anyone with the link. Some choices may not appear because an administrator has disabled them. Select whether recipients can edit or only view, and verify the names or addresses before sending. A link that grants editing access is not equivalent to a view-only link.

If you received the workbook from someone else, ask that person to share it with your account or adjust the permissions. Copying a link from a location you cannot access will not grant access by itself. Likewise, moving a file into a folder with different permissions can change who can open it, so check access after moving or uploading the workbook.

Review workbook state and file restrictions

Some workbook states can interfere with sharing or editing. Protected View is a safety feature for files Excel considers potentially unsafe; it is not a sharing error to bypass casually. If the file came from an untrusted source, verify it before enabling editing. A workbook opened as read-only may also be a copy that you cannot edit or share with the access you intended.

For a file that is already in OneDrive or SharePoint, check whether Excel has finished saving or syncing before trying again. If upload or sync is incomplete, wait for it to finish, then close and reopen the workbook from the cloud location. If a workbook is checked out, locked, or controlled by a SharePoint library policy, the owner or site administrator may need to resolve that restriction.

Do not assume the AutoSave switch is the Share control. AutoSave can indicate whether cloud changes are saved continuously, while Share controls access to the file. The buttons are related because cloud storage supports both features, but switching AutoSave on does not by itself grant permission to share. Also avoid creating multiple competing copies while troubleshooting; first identify which version contains the latest changes.

Update Excel and compare platforms

If the account, location, and permissions look correct, update Office and retry. In Windows Excel, go to File > Account > Update Options > Update Now, if that option is available. Organizations may manage updates centrally, so a work computer may not offer the same controls. Save your work before closing Office apps or installing an update.

Excel for the web is a useful comparison: open the workbook from OneDrive or SharePoint in a browser and check whether its Share option works there. If it does, the desktop app may need an update or a refreshed sign-in. If sharing fails in both places, file permissions, account access, or an organization policy is a stronger possibility. Excel for Mac also uses cloud storage and account access for sharing, but its menus and dialogs differ from Windows; do not rely on Windows ribbon paths when following Mac instructions.

On a phone or tablet, the Share control and dialog can differ by app version and screen size. The basic requirement remains a file in OneDrive or SharePoint and an account permitted to share it. If the mobile app cannot complete the action, check the file’s access in OneDrive or try Excel for the web before concluding that the workbook itself is damaged.

When to use another sharing method

If you cannot change the Share settings, contact the workbook owner or your organization’s Microsoft 365 administrator rather than trying to work around a policy. They can confirm whether external sharing is permitted, whether you have access to the correct SharePoint library, and which link type is allowed.

When cloud sharing is not available or is not appropriate, you can send a copy as an email attachment if your organization permits it. Remember that each recipient then has a separate file, and their edits will not automatically update your copy. For a single person who only needs to review information, a permitted view-only link may be better than an editable link. Choose the method based on the sensitivity of the workbook and whether recipients need to collaborate or simply receive a snapshot.

Frequently Asked Questions

Why is the Share button greyed out in Excel?
Common causes include a workbook saved only on your computer, an account that is signed out or lacks access, a read-only or protected file state, or an organization restriction. Check the file location and File > Account first.

Can I share an Excel file without OneDrive?
You can send a copy by another permitted method, such as an email attachment, but Excel’s cloud sharing link requires the workbook to be stored in OneDrive or SharePoint. An attachment is a separate copy, not a live shared workbook.

Why can’t I choose Anyone with the link?
Your organization or the file owner may have disabled that link type. Use an available option, such as sharing with specific people, or ask the site administrator whether the policy can be changed. Do not assume that a missing option means the Share button is broken.

Why can recipients open the link but not edit?
The link may grant view-only access, or the recipient may not have permission to edit the file or its SharePoint location. Review the link’s permission setting and confirm that the recipient is signed in with the account you shared with.

Does sharing a workbook send everyone a separate copy?
A OneDrive or SharePoint sharing link usually gives recipients access to the cloud file, subject to its permissions. Sending the workbook as an attachment creates a separate copy, so later edits do not stay synchronized.

What should I do if Share works in a browser but not in desktop Excel?
Confirm that desktop Excel is signed in to the same account, update Office if allowed, and reopen the cloud-stored workbook. If the web version also fails, investigate the file’s permissions or your organization’s sharing policy.

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.