There are three built-in ways to share an Excel file with multiple users: co-authoring through OneDrive or SharePoint, the legacy Shared Workbook feature, and emailing copies. Each works for a small sheet that a few people touch occasionally. Each breaks the same way once several people own different parts of the same file and update it every week. Here's how to set up each one, where it fails, and a fourth option built for that case.
Option 1: Co-authoring (OneDrive or SharePoint)
This is Microsoft's current answer. Save the workbook to OneDrive, OneDrive for Business or a SharePoint library, then share it. Everyone with the link opens the same file and sees each other's edits as they happen, with a coloured cursor per person.
- Save the file to OneDrive or SharePoint (File → Save As → your OneDrive).
- Click Share (top-right) and enter email addresses or copy a link. Set "Can edit".
- Make sure AutoSave is on. Everyone needs Excel 2016 or later, or Excel for the web.
It's free, it needs no add-in, and for a shared list or a sign-up sheet it's exactly right.
Where it breaks
Every keystroke is live. There is no draft — a placeholder, a what-if, a typo with an extra zero is visible to your colleague the instant you type it, and it can be quoted in a meeting before you've fixed it. The whole workbook is shared, so there's no private tab. And version history records autosaves, not decisions, so "who changed this number and why" has no answer. Most teams that try co-authoring on a budget or a forecast turn it off within a few weeks.
Option 2: The legacy Shared Workbook feature
Before co-authoring, Excel had "Share Workbook" — a mode that let several people open a file on a network drive and merged their changes on save. Microsoft has deprecated it and hidden the button, but it still exists.
- File → Options → Customize Ribbon → choose All Commands on the left.
- Find Share Workbook (Legacy) and add it to a ribbon group.
- Click it, tick "Allow changes by more than one user at the same time", save to a shared network folder.
Where it breaks
Shared Workbook mode disables a long list of features — you can't create tables, use data validation in some cases, insert charts freely, or run macros that touch those objects. Conflicts are resolved by whoever saves last, with a dialog nobody reads. Microsoft's own guidance is to use co-authoring instead. It survives only in offices with a file server and Excel habits from 2012.
Option 3: Email a copy to everyone
The oldest method, and still the most common at companies under 200 people. Attach the file, each person edits their part, sends it back, someone stitches it together.
Where it breaks
Five people means five files. The stitching takes an afternoon, introduces errors, and produces a sixth file nobody's version matches. Ask anyone who has consolidated a budget this way what "Budget_v7_FINAL_JD_edits_v2.xlsx" means.
Option 4: Share one worksheet, not the file
The three methods above share the same assumption: the file is the unit of sharing, and every edit is final the moment it's made. That assumption is what breaks when several people own different parts of the same workbook.
Symphony is an Excel add-in that changes both. You Invite a colleague to a single worksheet — the other tabs stay yours. Your edits stay private until you Submit with a one-line reason. Your colleague sees them only when they Refresh, and every change carries who, what, when and why. If two people change the same cell, both are shown both values; nothing is silently overwritten. The data lives in a database rather than in the file, which is what makes all of that possible — but you keep working in Excel, with your formulas, formatting and pivots intact.
The license is per month for your whole team, not per seat, on Excel 2016 or later for Windows.
Which should you use?
Co-authoring if the sheet is simple, short-lived, and nobody minds a half-finished edit being seen. Shared Workbook only if you're stuck on a network drive with no OneDrive. Email if it's genuinely one round-trip with one person. Symphony if the numbers matter, more than one person owns a piece of them, the file is updated week after week, and someone will eventually ask who changed what.
Related: what Excel's version history actually records · the five ways shared Excel breaks down · how Invite works
Frequently asked
In Symphony can multiple users edit an Excel file at the same time?
Yes, multiple users can edit the file at the same time and Sync by Choice when ready. Only the changed cells are exchanged with change reasons to help users better understand what changed.
How do I share only one sheet of an Excel workbook?
Excel has no built-in way to share a single sheet — sharing the file shares every tab. The usual workarounds are copying the sheet to a separate file (which then drifts) or hiding tabs (which anyone can unhide). Symphony's Invite command shares one worksheet and leaves the rest of the workbook private.
How do I stop other people overwriting my changes in a shared Excel file?
In co-authoring you can't — the last edit wins and there's no draft state. In Symphony, edits stay in your workbook until you Submit, teammates receive them only when they Refresh, and conflicts on the same cell are shown to both people rather than resolved silently.