How to Make a Shared Excel Document (And What to Know Before You Do)

Sharing an Excel file sounds straightforward — until you run into version conflicts, overwritten data, or a colleague who can't open the file at all. Getting it right depends on how you share, where the file lives, and what version of Excel everyone involved is running.

The Two Fundamentally Different Ways to Share Excel Files

Before clicking anything, it helps to understand that "sharing" an Excel document means two very different things depending on your setup:

1. Real-time collaborative sharing (cloud-based) Multiple people edit the same file simultaneously, changes sync instantly, and there's one version of truth. This is how Google Docs works, and Excel can do it too — but only when the file is stored in OneDrive or SharePoint.

2. Traditional file sharing (network or email-based) You send or grant access to a file stored locally or on a network drive. One person edits at a time, or you risk version conflicts. Excel had a legacy "Shared Workbook" feature for this, but Microsoft has deprecated it in favor of cloud collaboration.

Knowing which model fits your situation is the first real decision.

How to Share an Excel File via OneDrive (Recommended for Collaboration)

This method enables real-time co-authoring and works across Microsoft 365, Excel for the web, and Excel on mobile.

Step 1: Save the file to OneDrive or SharePoint Open your workbook, click File → Save As, and choose your OneDrive or SharePoint location. If the file is already saved locally, use File → Move → OneDrive.

Step 2: Use the Share button Once the file is in the cloud, a Share button appears in the top-right corner of Excel. Click it.

Step 3: Choose how to share You'll see two main options:

• Invite people — Enter email addresses and set permissions (Can edit or Can view)
• Copy link — Generates a shareable link with configurable permissions (anyone with the link, specific people, or your organization only)

Step 4: Set permissions carefully The default link type depends on your Microsoft 365 organization's settings. Always double-check whether you're sharing with "anyone" or restricting to specific people — especially for sensitive data.

Once shared, collaborators see each other's edits in near real-time, with colored cursors indicating who's working where. 🖱️

Sharing Without OneDrive: What Are the Options?

Not everyone has Microsoft 365 or wants files in the cloud. Here's what applies in other scenarios:

The legacy Shared Workbook feature (found under Review → Share Workbook in older Excel versions) allowed simultaneous editing on network drives, but it came with significant limitations: no support for modern Excel features like tables, conditional formatting rules, or data validation. Microsoft has been steering users away from it for years.

If cloud storage genuinely isn't an option, a network drive with strict check-in/check-out discipline is the practical fallback — one person edits at a time and communicates clearly with the team.

Permissions and Access Control: The Details That Matter

When sharing via OneDrive, permissions aren't all-or-nothing. You can:

• Grant view-only access to protect formulas or sensitive data
• Allow editing for collaborators who need to input data
• Set expiration dates on shared links (available on Microsoft 365 Business and Enterprise plans)
• Revoke access at any time from the Share panel or OneDrive's "Manage Access" settings

Password-protecting a file is a separate layer — done via File → Info → Protect Workbook → Encrypt with Password. This restricts who can open the file at all, before any sharing permissions even apply.

These two controls — sharing permissions and file-level encryption — operate independently and can be combined. 🔒

Co-Authoring Limitations Worth Knowing

Real-time co-authoring in Excel isn't completely frictionless. Some features behave differently or are restricted during active co-authoring sessions:

• PivotTable refresh may be delayed or require manual action
• Macros (VBA) can run but may cause conflicts if multiple users trigger them simultaneously
• Cell-level locking still works, but sheet protection applies globally
• AutoSave turns on automatically for cloud files and cannot be fully disabled in some configurations — which affects how Undo history behaves

These aren't dealbreakers for most users, but teams running complex, macro-heavy workbooks may encounter edge cases that simple data-entry sheets won't.

What Actually Determines Your Setup

The "right" way to share an Excel document isn't universal. The meaningful variables include:

• Whether your organization uses Microsoft 365 — this unlocks the full co-authoring stack
• Where your files currently live — moving to OneDrive has implications for IT policy in some workplaces
• How many people are editing simultaneously — two people is very different from twenty
• What's inside the workbook — macros, external data connections, and complex formatting can each introduce friction
• Your collaborators' Excel versions — older desktop versions (Excel 2016 and earlier) have limited co-authoring support; browser-based Excel for the web often handles it more reliably

Someone sharing a simple budget tracker with one colleague has a very different problem than a team of analysts co-editing a connected data model. The mechanics work the same way — but what breaks, what slows down, and what you'll need to plan around depends entirely on your specific combination of those factors.