Share an Excel File: The Complete Guide for Teams

Sharing an Excel file used to be simple: you emailed an .xlsx and waited. Then somebody sent it back with the wrong sheet renamed, somebody else replied-all with a version called FINAL_v3_use_this_one.xlsx, and the whole team lost an afternoon merging numbers. That workflow is dead. The modern way to share an Excel file uses the cloud — OneDrive or SharePoint — and a Share button that hands out a link instead of an attachment. You stay in one file. Everyone edits at once. The version history remembers who changed what.

This guide walks the whole thing end to end. We'll cover the new Share button (the one with a person and a plus sign), how Excel pushes files to OneDrive or SharePoint behind the scenes, and how co-authoring lets two, three, or fifteen people edit the same workbook in real time.

You'll see how to set permissions so the finance team can view but only the budget owner can edit, how to grab a copy-paste link for Teams or email, and how to deal with conflicts when two people change the same cell at the same time. We'll also cover the classic Shared Workbook feature buried under Review > Share Workbook — yes, it still exists in Excel 2019 and later, but it has real limits, and most teams shouldn't use it.

You don't need a Microsoft 365 subscription to read along, but you'll need one to share with co-authoring. The free Excel for the web works too — same Share button, same link, same live editing. Mobile users on iPad, iPhone, and Android can share and co-author from the Excel app, with one tap. By the end you'll know which method fits your team, how to set it up, and how to keep your data safe when the link leaves your inbox.

The Modern Way: Share Button + OneDrive or SharePoint

Open any workbook in Excel for Microsoft 365 (Windows, Mac, or web) and look at the top-right corner. You'll see a green Share button with a little person-plus icon. That button is the front door to every modern sharing workflow. Click it and Excel asks a question first: where is the file?

If the workbook only lives on your hard drive, Excel can't share it — there's nothing for a recipient to connect to. So the app prompts you to upload it. Pick a OneDrive folder for personal files, or a SharePoint site if your organization stores team data there. Excel uploads, swaps the local copy for the cloud copy, and the share dialog finally opens.

From there you have three choices. Type an email address to send a direct invite — the recipient gets a notification with a click-through link. Or click Copy link and paste the URL wherever you want: Teams chat, Slack, an email signature, a calendar event, anywhere. Or pick Send a copy if you really do want to send an attachment (the dialog still offers that for stubborn workflows). The link is the modern way. It points at one file in the cloud, not a frozen snapshot, so every viewer sees the current version every time they open it.

Before you send the link, check the permission line above the email box. It probably says Anyone with the link can edit. That's the default and it's almost never what you want. Click the gear (or the words themselves on Mac) to open the permission settings. You can switch to People you choose for invite-only access, restrict to People in your organization, set view-only mode, add an expiration date, or require a password. Tighten this before you copy the link, not after — once it's out, it's out.

Step-by-Step: Share From Excel Desktop (Windows or Mac)

Here's the full click path on the desktop app. Open the file. Top-right, click Share. If the file is local, Excel shows an upload prompt — pick OneDrive (Personal or Business) or a SharePoint site, confirm the folder, and let it finish uploading. The dialog that opens next has three sections: a permission line at the top, an address box in the middle, and link options at the bottom.

Don't rush past the permission line. Click it. Choose whether the link works for anyone, for people in your org, for specific people, or for existing access only. Toggle Allow editing off if you want read-only. Set an expiration date if the file is for a one-time review. Add a password for sensitive data.

Once permissions look right, type one or more email addresses, write a short message if you like, and hit Send. Or click Copy link to grab the URL and paste it yourself. Both work — sending creates a personalized invite, copying gives you the raw link. The little drop-down at the bottom shows everyone who already has access. Click any name to revoke, change from edit to view, or set a new expiration. You can audit and clean up sharing without ever leaving the dialog.

What changes on Mac

The Mac experience is almost identical, with two small differences. The Share button sits in the same corner but it's a person icon without text. The permission settings live behind a gear icon in the top-right of the share popup. Everything else — link copy, recipients, expiration, password — works the same way. One quirk: if you signed in to Excel for Mac with a personal Microsoft account, the SharePoint option only appears when you switch the active account to a work or school identity under Excel > Preferences > General > Personalize.

Co-Authoring: How Live Editing Actually Works

Co-authoring is the killer feature of cloud-shared Excel files. Once a workbook lives on OneDrive or SharePoint and you've shared the link with edit rights, every recipient who opens it sees a small colored avatar at the top of the window. Each editor gets a different color. As they click cells, you see a colored outline move around in real time — Sara's edits show up in blue, Marco's in green. Type a formula in B7 and Sara watches it appear letter by letter. She can keep working in row 12 without waiting.

Co-authoring works in Excel for the web, Excel for Microsoft 365 (desktop), and Excel mobile. It does not work in older perpetual licenses like Excel 2019 unless the file lives on a recent SharePoint server and AutoSave is on. AutoSave is the engine behind co-authoring — every keystroke gets pushed to the cloud, and every other editor's keystrokes get pulled down. If AutoSave is off (the toggle is in the top-left corner of the window), you're back to old-school manual save and the live cursor disappears.

The catch: co-authoring doesn't play nice with every Excel feature. Workbooks with strict open XML format, certain old chart types, ActiveX controls, or workbook-level password protection won't enter co-author mode. The Share button will still create a link, but recipients see a Checked out by another user message and have to wait. The fix is usually to remove the blocking feature (open password, replace ActiveX with a form control, save as .xlsx instead of .xls) and try again.

Permissions: Who Can See, Who Can Edit, Who Owns the File

Permissions in modern Excel sharing have three layers, and missing any one of them is how files leak. Layer one is the link itself: Anyone, People in your organization, People with existing access, or Specific people. The Anyone setting is the riskiest — that URL works for whoever finds it, including someone who fishes it out of a forwarded email. Default it to Specific people for anything sensitive.

Layer two is the action: edit or view. View-only mode is read-only — recipients can scroll, filter, even copy values, but they can't change cells, add sheets, or save back to your file. Edit mode lets them do everything short of deleting the file. There's no built-in middle ground like comment-only the way Word and PowerPoint have, but you can fake it with sheet protection: protect every sheet with a password before sharing, and edit rights stay limited to unlocked cells.

Layer three is sheet-level and workbook-level protection. The Share dialog handles file access; Review > Protect Sheet and Review > Protect Workbook handle what an editor can change inside the file. Combining the two is how you build a real workflow: anyone in finance can edit the input cells on Sheet1, but no one can rename a tab, delete a column, or alter the formulas on Sheet2. Set those protections before you share, not after — once co-authoring starts, you'll need everyone to close the file to change sheet protection.

Tracking who currently has access is a one-click job. Reopen the Share dialog, scroll the list at the bottom. You see every person, their permission, and the date they were granted access. Click any row to change the role or stop sharing. The Manage Access link opens a deeper panel that shows pending invites, expiration dates, and all the active sharing links — useful when you've been working on the file for months and don't remember who you sent it to in week one.

Conflicts, Version History, and How to Roll Back

Co-authoring usually feels seamless, but conflicts do happen. The most common case: two editors change the same cell within the same auto-save cycle. Excel resolves it on the spot — whichever change reached the cloud last wins, and the other editor sees the new value pop in. If the change is destructive (you typed over a formula, somebody else typed over the same cell), use version history to roll back.

Version history lives under File > Info > Version History on desktop, or the file name dropdown at the top of Excel for the web. OneDrive keeps 30 days of versions by default; SharePoint admins can extend that. Each version shows the timestamp and the editor who saved it.

Open any past version in a side window, compare it to the current file, and either restore the whole thing or copy specific cells back. Version history is the safety net that makes co-authoring viable — if you don't trust it yet, do one full pass and then test a rollback so you know exactly how it works.

Conflicts are different in the classic Shared Workbook feature. There's no real-time resolution. Instead, when two people save at the same time, Excel prompts the second saver with a Resolve Conflicts dialog showing both versions of each disputed cell. You pick one or the other, one cell at a time. It works, but it's slow and error-prone, which is why co-authoring on OneDrive replaced it for everything except the most specific compatibility scenarios.

The Classic Shared Workbook (Legacy)

If you're in Excel 2019 or later, you might never see the old Share Workbook command — it's hidden by default. To restore it, go to File > Options > Quick Access Toolbar, change Choose commands from to All Commands, find Share Workbook (Legacy), and add it to your toolbar. Now you can click it to turn on the old shared mode. The dialog has two tabs: Editing (turn sharing on, see who else has the file open) and Advanced (change-tracking duration, conflict resolution rules, update frequency).

Why would you ever use this? Three reasons. First, your team relies on a SharePoint server that's too old for co-authoring (anything before SharePoint 2016 with the Online Server feature pack). Second, you need change tracking inside the file rather than version history outside it.

Third, you have a custom add-in or VBA macro that depends on the old shared workbook event model. Outside those niche cases, skip it. Shared Workbook disables a long list of features: tables, slicers, conditional formatting changes, deleting sheets, merging cells, sorting by color, and pivoting. The list of disabled features is longer than the list of supported ones.

One more catch — shared workbooks live on a file share (a network drive or local server), not in OneDrive. They have no link to copy. Sharing means: drop the file on a path everyone can reach, turn on the shared mode, and tell people the file path. It's the workflow we all used in 2008, and it's the workflow most modern teams replaced for a reason. Use co-authoring on OneDrive or SharePoint instead, and only fall back to the legacy mode when something specific forces your hand.

Mobile Sharing and Field Workflows

The Excel mobile app on iPad, iPhone, and Android handles every modern sharing flow described above. Tap the file. Tap the person-plus icon. Type emails or copy a link. Permission controls live one tap deeper under Manage. Mobile co-authoring works exactly like desktop — you see the colored avatars at the top, the live cell outlines, the AutoSave status.

The mobile app does have one extra superpower: it shares straight from camera-roll imports. Take a photo of a printed table, let Excel's Insert Data from Picture turn it into a real range, and share the resulting workbook in the same session.

For teams in the field, the right setup is OneDrive sync on every device plus the mobile app for quick edits. A foreman captures inventory on their phone, the office desktop sees updates seconds later, and a finance analyst pivots the data in Excel for the web — all in one shared file. The link never changes. The version history captures every save.

Exporting a Snapshot Before You Share

Sometimes you don't want a live file. You want a frozen snapshot — a copy you can mail without worrying that you'll keep working on it and overwrite what the recipient is reviewing. The cleanest way is File > Export > Create PDF/XPS. PDF preserves layout, locks the data, and is universally readable. Or use File > Save a Copy to drop a duplicate .xlsx into a separate folder, then share that copy instead of the original. Both approaches are safer than emailing the live workbook to someone outside your organization.

Putting It All Together

Sharing an Excel file the modern way is a three-step move. Get the file to the cloud (OneDrive or SharePoint). Click Share. Pick the right permission before you copy the link or email the invite. That's it. The cloud handles the rest — co-authoring, version history, conflict resolution, audit trail.

The legacy Shared Workbook is still in the box, but it's a museum piece. Use it only when a compliance requirement, an old server, or a custom macro forces your hand. For every other workflow — small teams, big companies, mobile field reps, browser-only Chromebook users — co-authoring on OneDrive or SharePoint is the cleaner, safer, faster choice. You stay in one file. Your team edits at once. Excel keeps the history. The version everybody sees is the version that's actually current, and the email thread of FINAL_v3_use_this_one.xlsx finally goes away.