How to Make Excel Allow Multiple Users at the Same Time

To let multiple people use an Excel file at the same time, save the workbook to OneDrive or SharePoint, click Share in the upper-right corner of Excel, enter their email addresses, and send the invite. Everyone who opens it can edit together. Microsoft calls this co-authoring.

These steps cover Excel for Microsoft 365 on Windows and Mac, Excel for the web, and the Excel mobile apps. They follow Microsoft’s co-authoring guide. Co-authoring replaced the old Shared Workbook feature, which is covered near the end for anyone who still needs it.

Subscription Needed for Co-Authoring

  • A Microsoft 365 subscription, if you want to co-author in the Excel desktop app. Sign in to Excel with that account. On a work or school account, your admin may control when the newest version reaches you.
  • The latest version of Excel for Microsoft 365. Not sure what you have? Here is how to check which version of Excel you’re using.
  • A workbook saved as .xlsx, .xlsm, or .xlsb. If your file is an older type, open it and use File > Save a Copy to save it as an Excel Workbook (.xlsx). The Strict Open XML Spreadsheet format doesn’t work with co-authoring.
  • A place to store the file: OneDrive, OneDrive for work or school, or SharePoint in Microsoft 365. SharePoint sites that your company hosts on its own servers don’t support co-authoring, and neither do Dropbox, Box, Google Drive, network folders, or your computer’s hard drive.

How Co-Authoring Works

Co-authoring means one copy of the workbook lives in the cloud and everyone edits that copy. AutoSave sends each change to the cloud as you make it, so other people see it within seconds. Nobody has to email files back and forth, and nobody ends up with “Budget final v3.xlsx” on their desktop.

The catch is that every person has to open the cloud copy. If someone downloads the file and edits it on their own computer, their changes stay on their computer.

How to Let Multiple Users Edit an Excel Workbook

  1. Upload the workbook to OneDrive or SharePoint in your web browser, then select the file name. It opens in Excel for the web in a new tab.
  2. To work in the desktop app, select Editing in the upper-right corner, then Open in Desktop. If you see a yellow Protected View bar, click Enable Editing. Other reasons a cell refuses changes, such as Protected View or a protected sheet, are sorted out in how to edit an Excel sheet.
Excel for the web Editing menu with the Open in Desktop App option
Select Editing > Open in Desktop App to work in Excel.
  1. Click Share in the upper-right corner. The sharing box opens.
  2. Type the email addresses of the people you want to add, separated by semicolons, or pick them from the list that appears as you type.
  3. Check that the permission is set to Can edit. This is the default. Choose Can view for anyone who should only read the file.
Excel Share box with email addresses added and the permission set to Can edit
Add people and check that the permission says Can edit before you send.
  1. Add a message if you want, then select Add or Send to send the invitation. Each person gets an email with a link. To share the link yourself instead, choose Share > Copy link and paste it into a chat or email.
  2. Make sure AutoSave is on in the upper-left corner of Excel.
Excel title bar for a sample OneDrive workbook with AutoSave switched On and the file status Saved
Make sure AutoSave is on before others start editing.
Illustration of the Excel co-authoring steps: save to OneDrive or SharePoint, click Share, add email addresses with Can edit, then send

Already working on the file in desktop Excel? You can start from there. Use File > Save As and pick your OneDrive or SharePoint location, or click Share and let Excel upload the file to OneDrive for you. Then continue at step 3.

If you use the OneDrive app on your PC, it helps to keep OneDrive syncing so the file in File Explorer is always the latest copy. A paused sync is one of the most common reasons other people’s changes don’t show up.

How to Tell That Co-Authoring Is Working

When other people open the file, their pictures or initials appear in the upper-right corner. A “G” means a guest from outside your organization. That means you are co-authoring.

Excel workbook showing co-author icons and colored cell outlines for other editors
Colored cell outlines show where co-authors are working.

Other people’s selected cells show in colors such as blue and purple. Your own selection is green. Hover over a colored cell to see who is there, or select a person’s picture or initials and choose Go to to jump to where they are working.

How Other People Open the Shared File

  1. Open the email invitation and select the link. The workbook may open in Excel for the web in the browser.
  2. Edit right there, or select Editing > Edit in Desktop to switch to the Excel app.
  3. People with the latest Excel can also go to File > Open > Shared with Me and pick the workbook.
Excel File Open page with Shared with Me selected listing a shared workbook
Find files others shared under File > Open > Shared with Me.

Microsoft lists these versions as supporting co-authoring:

Excel version Co-authoring
Excel for Microsoft 365 (Windows) Yes, latest version, signed in
Excel for Microsoft 365 for Mac Yes, latest version, signed in
Excel for the web Yes
Excel for Android and Excel for iOS Yes
Excel Mobile Yes
Excel 2016, 2019, 2021 LTSC No, and opening the file locks it for others

On the mobile apps, turn on AutoSave from the File menu. On Android it is under File > More > AutoSave, and on iPhone or iPad under File > AutoSave.

How to Avoid Overwriting Each Other

Excel handles most edits on its own, but two people changing the same cell is still a problem. The last change saved wins, whether it was saved by AutoSave or with Save. A little planning helps:

  • Give each person their own sheet or range, and put their name in the sheet tab or a heading.
  • Leave notes for each other with comments instead of typing into cells someone else owns.
  • Protect formulas and headers so people can only type in input cells. Excel lets you lock cells and leave only the input cells open.

If someone works offline with OneDrive sync, their changes merge all at once when the computer reconnects, which makes conflicts more likely.

Why Does Excel Say the File Is Locked?

Microsoft’s Excel file is locked for editing page lists the usual causes. The most common is that one person opened the workbook in a version that doesn’t support co-authoring, such as Excel 2019. That locks it for everyone else. Ask them to close it and use Excel for the web instead.

Other causes and fixes:

  • You left it open somewhere else. Close the file on every device, then wait a few minutes for the lock to clear.
  • Wrong location or format. Move the file to OneDrive or SharePoint, and save it as .xlsx, .xlsm, or .xlsb.
  • OneDrive sync problems. Update the OneDrive app and make sure syncing isn’t paused.
  • Blocking settings. Turn off Shared Workbook, remove the password under File > Info > Protect Workbook, or clear Refresh data when opening file in a table’s Connection Properties.
  • An add-in. Turn it off under File > Options > Add-Ins, select Excel Add-ins, click Go, and clear its check box.
  • View-only access. If the file opens but you can’t type, the owner shared it as view only. Ask them for edit access. On the owner’s side, the fix is to change sharing permissions in OneDrive.

If You Can’t See Other People’s Changes

Wait a minute or two first. Then check that AutoSave is on, that everyone selected Enable Editing, that OneDrive syncing isn’t paused, and that the file isn’t read-only. On Windows, go to File > Info and fix any errors listed there.

If Excel shows Refresh recommended or Upload failed, someone probably used a feature that co-authoring doesn’t fully support. With no unsaved changes, select Refresh. To keep your unsaved work, use Save a Copy under a new name, reopen the cloud file, and paste your changes back in.

How to Undo Changes or Stop Sharing

To go back to an earlier copy, choose File > Info > Version History and open a past version. Wait until no one else is editing before you restore it.

To stop people from editing, remove their access or the sharing link from the file’s Manage access settings in OneDrive or SharePoint. If you only want them to look, you can make an Excel spreadsheet read-only for others.

Manage access for a sample Excel workbook with a person’s permission menu open and Remove direct access highlighted
Choose Remove direct access to stop sharing with that person.

What the Sharing Controls Looked Like in Excel 2610

I opened a new, unsaved workbook in Excel for Microsoft 365 (Version 2610, Current Channel) on Windows 11 to see what a first-time sharer runs into.

  • The Review tab had Proofing, Performance, Accessibility, Language, Changes, Comments, Notes, Protect and Ink groups. There was no Share Workbook button, and Show Changes in the Changes group was grayed out.
  • The Share button at the top right opened a menu with Share, Copy Link, Link to this Sheet, Get Excel Mobile App and Manage Access. Copy Link and Manage Access were grayed out.

Those grayed-out items are the clue: they turn on once the workbook is saved to OneDrive or SharePoint. If co-authoring options look unavailable, save the file to the cloud first, then come back to Share.

What About the Old Shared Workbook Feature?

Shared Workbooks is the older way to let several people edit one file. It has been replaced by co-authoring. It only works with a file on a network folder, not OneDrive or SharePoint, and it can’t be edited in Excel for the web. Newer versions of Excel hide the Share Workbook button, so you have to add it back before you can use it.

It also blocks many features while it is on, including tables, charts, PivotTables, conditional formatting, data validation, merged cells, and macros. Turning it on means saving the file to a network location, then selecting Review > Share Workbook and checking Allow changes by more than one user. To turn it off, clear that same box. Unless your company requires it, use co-authoring. See Microsoft’s Shared Workbook page for the full list of limits.

For example, you’ll need to stop sharing before you can change or remove data validation rules.

Excel Co-Authoring Questions

How do I share an Excel file with multiple users?

Save it to OneDrive or SharePoint, click Share, enter each person’s email address, and leave the permission on Can edit. Everyone can then work in the same file at the same time. Teams that plan in OneNote can then link Excel to OneNote pages so everyone opens the same shared workbook.

Can multiple people edit an Excel file on a shared network drive?

Only with the old Shared Workbook feature, which turns off many Excel features. Co-authoring needs OneDrive or SharePoint in Microsoft 365.

Do the people I share with need Microsoft 365?

Not to edit in the browser. Excel for the web is on Microsoft’s list of supported co-authoring versions, and it opens from the invite link. To co-author in the desktop app, each person needs the latest Excel for Microsoft 365.

Can two people edit the same cell at once?

They can, but the last change saved wins. Split the work by sheet or range to avoid overwriting each other.

Is there a free way to do this?

Yes. Excel for the web is free with a Microsoft account, and you can co-author files saved in OneDrive. Google Sheets also lets many people edit one spreadsheet at no cost. Here is how to create a Google Sheets spreadsheet in Google Drive.

Want linked cells and imported data to stay current too? You can set Excel to update a spreadsheet automatically.