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
- 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.
- 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.

- Click Share in the upper-right corner. The sharing box opens.
- 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.
- Check that the permission is set to Can edit. This is the default. Choose Can view for anyone who should only read the file.

- 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.
- Make sure AutoSave is on in the upper-left corner of Excel.


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.

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.
- Open the email invitation and select the link. The workbook may open in Excel for the web in the browser.
- Edit right there, or select Editing > Edit in Desktop to switch to the Excel app.
- People with the latest Excel can also go to File > Open > Shared with Me and pick the workbook.

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.

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.
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.

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.