Excel Share Mode: How to Keep Your Workbook Shared

How-to basics · Updated November 20, 2026

To keep an Excel workbook shared, save it to OneDrive or SharePoint, select the Share button, and give the intended people permission to edit or view it. Leave those permissions in place; closing Excel does not normally turn sharing off. For Microsoft 365, cloud co-authoring is the recommended way to work together. Excel’s older Shared Workbook (Legacy) feature is different and should be used only when a workplace specifically requires it.

Before you start, decide whether other people need to edit the same file or only view it. Make a backup if the workbook is important, and check that you have permission to store it in the chosen OneDrive or SharePoint location. The steps below are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • Excel for Microsoft 365 and a Microsoft account, or a work or school account with access to OneDrive or SharePoint.
  • A workbook saved in a format suitable for sharing, such as .xlsx. If it is an older .xls file, save a separate modern copy with File > Save As and choose Excel Workbook (.xlsx), after checking that conversion will not remove features you need.
  • The email addresses or names of the people who should have access, plus a decision about whether they can edit or only view.

Step-by-Step

  1. Check which kind of sharing you need. For most people, share a cloud-stored workbook so everyone works in the same file and can see changes as they happen. Do not look for a permanent on/off switch called share mode: modern Excel sharing is based on the file’s location and access permissions. If instructions from your organization specifically mention Shared Workbook (Legacy), follow the legacy method described in step 8 instead.
  2. Save the workbook to OneDrive or SharePoint. In Excel, select File > Save As, choose OneDrive or a SharePoint site that you can access, select a folder, and save the workbook. If the file is already in the right cloud location, use File > Info to check its location rather than making another copy. Avoid saving it to a local folder such as Documents or to a USB drive if you want other people to coauthor in the same file.
  3. Confirm that the cloud copy is the one you intend to share. Check the workbook name and folder in the title bar or under File > Info. If you have both a local copy and a cloud copy open, close the unintended one so edits do not end up in the wrong file. If you changed the name or moved the workbook, share the current cloud copy; an old link may still point to the previous location or file.
  4. Open the sharing controls. Select the Share button near the upper-right corner of the Excel window. If Excel asks you to upload or save the workbook online first, approve that only if the suggested OneDrive or SharePoint location is appropriate. You can also share from OneDrive or SharePoint in a browser, but check that you are sharing the same file you just verified in Excel.
  5. Choose who can use the workbook. Enter the people’s names or email addresses in the sharing box. Open the permission setting and select Can edit if they need to change cells, or Can view if they only need to read the workbook. Add a brief message if useful, then select Send. The recipients receive access through their accounts; sending a link does not by itself give everyone permission unless the link setting allows it.
  6. Set link access carefully if you use a link. In the Share dialog, open the link settings before copying the link. Choose an option such as specific people or people in your organization, as appropriate, and check whether the link grants editing or viewing. Organization policies can limit which link choices are available. Use the narrowest access that meets your needs; a link that allows anyone who receives it to edit can be forwarded beyond the intended group.
  7. Keep the file saving and let collaborators open the shared copy. For a cloud workbook, leave AutoSave turned on if it is available in the title bar. Wait for syncing to finish before closing Excel, especially after a large edit or a weak internet connection. Ask collaborators to open the shared link rather than emailing separate attachments. When coauthoring is working, Excel may show other people’s presence or the cells they are editing; those indicators can take a moment to appear.
  8. Verify that access remains in place. After sending the invitation, use the Share controls or the file’s access-management page in OneDrive or SharePoint to review who has access and whether each person can edit or view. Close and reopen the workbook from its cloud location, then confirm that it still shows the shared file and syncs normally. To keep it shared, do not remove people’s access, delete the cloud file, or use a command such as Stop sharing. Closing Excel, signing out of the desktop app, or turning off your computer does not usually revoke other people’s access.

If you specifically need the older shared-workbook feature: In Excel for Microsoft 365 on Windows, look for Review > Share Workbook (Legacy). If the command is missing, open File > Options > Quick Access Toolbar, set Choose commands from to All Commands, select Share Workbook (Legacy), and choose Add. Open the command and select the option that allows changes by more than one user at the same time, then confirm. This legacy method has restrictions and is not the same as the modern Share button. Use it only when required, and keep a backup before changing the workbook’s sharing setup.

Common Mistakes

  • Sharing a local file or an attachment: People may each edit separate copies, so their changes will not appear together. Share the OneDrive or SharePoint file itself and have everyone use its link.
  • Assuming that a link automatically grants access: A recipient can see an access-denied message if the link is restricted to someone else or the wrong account. Check the link audience and confirm the recipient’s account has permission.
  • Giving edit access when view access is enough: Editors can change content, formulas, and sometimes workbook structure. Choose view permission for readers, and grant edit rights only to people who need to make changes.
  • Confusing modern sharing with legacy sharing: The Share button and Shared Workbook (Legacy) are separate features. Avoid turning on the legacy option just because you want to keep a workbook available to colleagues.
  • Moving or renaming a file without updating the group: Some links may no longer lead people to the expected copy. Share the new location and ask collaborators to stop using outdated attachments or bookmarks.

Tips

  • Use a clear filename and a stable team folder, such as a project folder on SharePoint, so people can identify the authoritative version.
  • Agree on who may edit the workbook and who should only view it. For sensitive or easily damaged sheets, consider protecting worksheet cells separately; protection is not a replacement for file permissions.
  • Use comments or cell notes to explain important edits, and agree on how the team will handle simultaneous changes to the same area.
  • Review access periodically, especially when a project ends or a team member changes roles. Remove access that is no longer needed, while retaining the permissions required by current collaborators.
  • On Excel for the web, open the workbook from OneDrive or SharePoint and use the Share button near the top of the page. On Mac, the Share button and cloud-sharing approach are similar, although button placement and some dialog labels can differ from Windows.

Troubleshooting

The Share button is missing or unavailable. First save the workbook to OneDrive or SharePoint and sign in to the account that has access to that location. If you are offline, using an unsupported file type, or working in a folder where you lack permission, cloud sharing may not be available. Try opening the file directly from OneDrive or SharePoint in a browser, or ask the site owner or administrator to check your access.

A recipient cannot open the link. Check that you typed the correct email address and that the link’s audience includes that person. If your organization restricts external sharing, an outside recipient may not be allowed to open it. Send a new invitation to the account they use to sign in, or ask the SharePoint or Microsoft 365 administrator about the organization’s sharing policy. Do not change the link to broad access unless that is permitted and appropriate.

Edits are not appearing for other people. Confirm everyone opened the same cloud file, not a downloaded copy or email attachment. Check the AutoSave indicator and internet connection, then wait for pending changes to sync. If Excel reports a conflict or asks you to upload changes, read the prompt carefully and preserve a backup before choosing which version to keep. Reopen the shared file after syncing and check whether the edits are present.

The workbook opens read-only or collaborators cannot edit. Review their permission in the Share or access-management controls and change it to Can edit only if appropriate. Also check whether the workbook is checked out, protected by your organization, or opened in a mode that prevents editing. A protected worksheet can restrict what someone does even when they have file-level edit access; the workbook owner may need to adjust sheet protection.

The legacy command is unavailable or the workbook behaves differently. Confirm that you added the command from File > Options > Quick Access Toolbar and selected the legacy command, not the regular Share button. Legacy sharing has compatibility limitations and can conflict with newer workbook features. If it cannot support the workbook or users, save a backup and move the team to OneDrive or SharePoint coauthoring instead.

Frequently Asked Questions

Does Excel have a keep-in-share-mode switch?
No single switch keeps modern Excel sharing on. The workbook stays shared because it remains in OneDrive or SharePoint and the access permissions remain in effect. The legacy Shared Workbook feature is a separate, older option.

Will the workbook stay shared when I close Excel?
Usually, yes. Closing the app does not remove other people’s permissions. Let pending changes finish syncing before you close, and avoid deleting or moving the cloud file if collaborators still need it.

Can several people edit the same workbook at once?
Yes, with supported Excel versions and a workbook stored in OneDrive or SharePoint, collaborators can coauthor the same file. They should open the shared cloud copy and use an account that has edit permission. A downloaded copy is separate.

Can I share an Excel workbook without OneDrive?
You can send a copy or store a file in another shared location, but that is not necessarily the same as live coauthoring in one cloud workbook. For simultaneous editing through Excel’s modern sharing features, use OneDrive or SharePoint. Your organization may provide another approved collaboration service.

How do I stop sharing with one person?
Open the file’s Share or access-management controls, find that person, and remove their access or change it to view-only if that is what you need. The exact control can vary between Excel and the OneDrive or SharePoint website. Removing one person’s access does not necessarily disable access for everyone else.

Should I use Shared Workbook (Legacy)?
Only if a specific workflow or organization requires it. It has feature limitations and is not the normal way to coauthor in Microsoft 365. For a new shared workbook, use OneDrive or SharePoint and the Share button.

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.