How to Keep Excel in Share Mode for Multiple Users

How-to basics · Updated November 20, 2026

To keep an Excel workbook in the old shared-workbook mode, enable Share Workbook (Legacy) and save the file in a shared network folder. In Excel for Microsoft 365 on Windows, add that legacy command to the Quick Access Toolbar, open its dialog, and select Allow changes by more than one user at the same time. This setting belongs to that workbook, not to Excel as a whole. For most teams, Microsoft 365 co-authoring through OneDrive or SharePoint is the better way to keep one workbook editable by several people.

Before changing anything, decide which kind of sharing you mean. The older shared-workbook feature is intended for a file on a network location and has limitations. Modern co-authoring uses a workbook saved in OneDrive or SharePoint and the Share button. These are different systems: enabling the legacy option does not turn on cloud co-authoring, and a cloud sharing link does not enable the legacy setting.

What You’ll Need

  • Excel for Microsoft 365 desktop on Windows if you want to enable the legacy shared-workbook feature. Excel for the web does not provide that legacy feature.
  • For legacy sharing, a workbook saved as an Excel workbook, such as an .xlsx file, and a shared network folder that each editor can access. Your organization may need to grant users permission to read, write, and save files in that folder.
  • For modern co-authoring instead, a Microsoft 365 work or school account, or another eligible Microsoft account, and a workbook stored in OneDrive or SharePoint with edit access for collaborators.
  • A backup or an untouched copy of the workbook before changing sharing settings. This gives you a safe reference if the team decides to switch methods or the file behaves unexpectedly.

Step-by-Step

  1. Choose the sharing method. Use legacy sharing only if you specifically need the old shared-workbook feature, typically because a workflow relies on it or the file must remain on a shared network drive. If you simply want several people to edit the same workbook, choose co-authoring instead. It is more current and generally works better with simultaneous editing. Do not try to combine the two approaches on the same working copy.
  2. Save a backup and put the working file in the right place. For legacy mode, save the workbook in a folder all editors can access on your organization’s network. Avoid emailing separate copies: users need to open the same file from the shared location. For co-authoring, save the file to OneDrive or SharePoint. If the workbook is currently in the wrong location, use File > Save As to create the working copy in the correct one, then tell collaborators which copy to use.
  3. Add the legacy sharing command to Excel. In Excel for Microsoft 365 on Windows, choose File > Options > Quick Access Toolbar. In Choose commands from, select All Commands, then find Share Workbook (Legacy). Select it, choose Add, and click OK. The command should now appear in the Quick Access Toolbar above the ribbon. If you also need older change-tracking controls, you can add Track Changes (Legacy) separately, but it is not required just to enable sharing.
  4. Open the legacy sharing dialog. Click the new Share Workbook (Legacy) button. On the Editing tab, select Allow changes by more than one user at the same time. This also allows workbook merging. This is the setting that makes the workbook a legacy shared workbook. Click OK. If Excel asks you to save the file, confirm the save so the sharing setting is stored in the workbook.
  5. Set the change-history options that suit the team. In the same dialog, review the Advanced tab. Depending on the choices shown in your Excel version, you can set how long change history is kept and how often the workbook checks for other users’ updates. Choose a practical interval for your workflow: more frequent updates can make changes appear sooner, while less frequent checks may suit a slower process. These settings do not replace saving the workbook, and legacy updates are not as immediate as co-authoring.
  6. Confirm that the workbook stayed shared. Save, close the dialog, and reopen Share Workbook (Legacy). Check that the multi-user editing option remains selected. Close the dialog without changing anything, then save the workbook again. The option is saved with this workbook; adding the button to Excel only makes the command available and does not enable sharing in every file.
  7. Tell collaborators how to open the shared file. Give legacy users the network path and ask them to open that file directly in desktop Excel, rather than downloading a copy or opening an email attachment. Ask everyone to save changes and close the workbook when finished. For co-authoring, use the top-right Share button to invite people or copy a link with edit permission. Collaborators should open the link and sign in with an account that has access.
  8. Make a small test before relying on it. Ask one other person to open the same legacy file and make a harmless change in a test area. Save, then confirm that both users can see the update. For co-authoring, check that the other person appears in the workbook and that their edits show up. Remove the test entry afterward. A test can reveal a permissions issue, a stale copy, or a sharing method mismatch before the team edits important data.

To keep modern co-authoring available: save the workbook to OneDrive or SharePoint, select Share, and give collaborators edit permission. Keep the file in that cloud location and use the same shared link. Co-authoring is not a persistent legacy checkbox; access comes from the file’s location and sharing permissions. If someone sends a downloaded attachment, that copy is no longer the live shared workbook.

Common Mistakes

  • Confusing the two kinds of sharing. The Share button and its cloud link are for OneDrive or SharePoint co-authoring. Share Workbook (Legacy) is a separate Windows desktop command. If you are looking for one feature in the other workflow, it may seem as though Excel has lost the setting.
  • Saving a separate copy for each editor. A filename such as Budget-final2.xlsx is a different workbook, not another participant in the shared file. Legacy users must open the same network copy; co-authors must use the same OneDrive or SharePoint file.
  • Assuming every workbook feature works in legacy mode. The old shared-workbook format restricts some Excel features and editing actions. If Excel warns that a feature is incompatible, read the warning rather than removing it automatically. Check whether the team can use co-authoring or revise the workbook design before proceeding.
  • Forgetting folder permissions. Seeing a file in a shared folder does not always mean you can save changes there. Each legacy editor needs appropriate write access. A read-only file or a folder with limited permissions will not become editable just because the shared-workbook checkbox is selected.
  • Expecting simultaneous edits to merge perfectly. If two people change the same cell in a legacy workbook, Excel may need to resolve a conflict. Agree who owns important input areas, and avoid editing the same cells at once. Shared mode does not remove the need for a clear process.

Tips

  • Give the shared file a clear name and location, then communicate that exact path or link. A short instruction such as “open the file in the Team Finance folder, not the attachment” prevents many version mix-ups.
  • Make a dated backup before switching sharing methods or making major structural edits. Keep the backup outside the live working location or label it clearly so no one mistakes it for the current file.
  • For a legacy workbook, use the Advanced options deliberately. A short change-history period can reduce stored history, but it may also make older edits unavailable for review. Choose the retention and update behavior with the team’s record-keeping needs in mind.
  • Protect the process with simple coordination: assign owners to key sheets, use separate input areas when practical, and ask users to save and close when they finish. This is especially useful when the workbook is large or has complex formulas.
  • When you do not have a specific reason to use legacy mode, prefer co-authoring. It is designed for people to work in one cloud-hosted workbook, and it avoids the legacy feature’s compatibility limitations. Check your organization’s policies before moving a work file to a cloud location.

Troubleshooting

The Share Workbook (Legacy) command is missing. It is not always visible on the ribbon by default. Add it using File > Options > Quick Access Toolbar and the All Commands list. If the command is unavailable or disabled, your Excel edition, organization policy, or workbook state may prevent its use. Excel for the web does not support the legacy shared-workbook feature; use the Windows desktop app for these steps.

The sharing checkbox will not stay selected. First make sure you are using the legacy dialog and that the workbook is saved in a supported shared network location. Save the file after selecting the option, close it, and reopen the same file to check. If Excel reports unsupported features, inspect the warning and resolve the compatibility issue rather than repeatedly toggling the setting. If your organization manages Office settings, ask your administrator whether legacy sharing is restricted.

Another person can open the file but cannot save. Check whether the workbook opened as read-only, whether another process has locked it, and whether the person has write permission for both the file and its folder. Have them close the workbook, confirm they are opening the network copy rather than a download, and try again. If the problem continues, the folder owner or IT administrator may need to adjust access.

Changes are missing or appear late. In legacy mode, verify that everyone saved and that users are opening the same path. Review the update options on the dialog’s Advanced tab and allow time for the file to refresh. If two editors changed the same cell, check for a conflict prompt. With co-authoring, check the internet connection, sign-in account, and edit permission, then confirm the file is still in OneDrive or SharePoint.

Excel says a feature is incompatible or sharing cannot be enabled. The warning usually points to a feature that does not work with legacy sharing. Save a backup, identify the affected feature, and decide whether it can be removed or whether the workbook should use co-authoring instead. If the workbook depends on the feature, do not discard it just to force legacy sharing; ask the workbook owner or IT support to help choose a safe route.

You are using a Mac or Excel for the web. These instructions describe the legacy feature in Excel for Microsoft 365 on Windows. Excel for the web is for modern co-authoring, not enabling the legacy shared-workbook option. On Mac, use the Share workflow with a workbook stored in OneDrive or SharePoint; ribbon locations and available legacy controls differ from Windows.

Frequently Asked Questions

Does Excel remember share mode after I close the workbook?

For legacy sharing, the multi-user setting is stored in the workbook when you save it. Reopen the same shared file and check the legacy dialog if you want to confirm. It is not a global Excel preference, so a new workbook needs its own sharing setup.

Is Share Workbook (Legacy) the same as the Share button?

No. Share Workbook (Legacy) enables the older network-file sharing feature. The ribbon’s Share button is used for modern sharing through OneDrive or SharePoint. Choose one method based on where the file is stored and how your team works.

Can people use legacy shared mode in Excel for the web?

No. The legacy shared-workbook feature is for desktop Excel, and these setup steps are for Windows. For browser editing, save the workbook to OneDrive or SharePoint and grant collaborators edit access so they can co-author.

Why can’t I find the legacy option in Review?

Newer Excel versions may not show the command on the ribbon automatically. Add Share Workbook (Legacy) through File > Options > Quick Access Toolbar and All Commands. If it is not available there, use modern co-authoring or check with your administrator.

What is the best way to keep several people editing one workbook?

For most Microsoft 365 teams, store the workbook in OneDrive or SharePoint and use the Share button to grant edit access. Use legacy shared mode only when you have a specific need for it and understand its limitations. Either way, make sure everyone works in the same live file, not separate copies.

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.