How to Create a Shared File in Excel: Everything You Need to Know

Sharing an Excel file sounds simple — until you realize there are several different ways to do it, and the "right" method depends heavily on how you work, who you're working with, and what version of Excel you're running. Here's a clear breakdown of how Excel file sharing actually works.

What "Sharing" an Excel File Actually Means

There's an important distinction worth understanding upfront. Sharing a file can mean two very different things:

• Sending a copy — someone receives their own version of the file, edits it independently, and changes aren't reflected in your original.
• Collaborative sharing — multiple people work in the same file simultaneously, with changes visible in real time or synced on save.

Most people asking this question are looking for the second option. That's where Excel's sharing features come in — and where the differences between setups start to matter.

The Two Main Paths to Sharing an Excel File

1. OneDrive / SharePoint (Cloud-Based Sharing)

This is the modern, recommended approach for most users with Microsoft 365. When your file is saved to OneDrive or SharePoint, you can share it with others through Excel's built-in Share button (top-right corner of the desktop app, or via Excel Online).

From there, you can:

• Enter email addresses for specific people
• Choose whether recipients can edit or only view
• Generate a shareable link with custom permissions
• Set an expiration date on access (available in some Microsoft 365 plans)

Changes made by collaborators appear in near real time. You can see who's editing what, with each user's cursor shown in a different color. This is sometimes called co-authoring.

2. Legacy Shared Workbooks (Local Network Sharing)

Older versions of Excel — and some enterprise environments still running Excel 2016 or earlier — use a feature called Shared Workbooks. This was the original method for multi-user editing over a local network.

To enable it (in versions that still support it):

1. Go to Review tab
2. Click Share Workbook
3. Check the box that allows changes by more than one user at a time

⚠️ Microsoft has largely deprecated this feature. It has known limitations — it disables certain Excel features like table formatting, conditional formatting rules, and some formulas. If you're on a current Microsoft 365 subscription, OneDrive-based sharing is almost always the better path.

Step-by-Step: Sharing via OneDrive (Microsoft 365)

1. Save the file to OneDrive or SharePoint — if it's stored locally, Excel will prompt you to move it to the cloud before sharing.
2. Click the Share button in the top-right corner of Excel.
3. In the sharing panel, type the email address(es) of the people you want to share with.
4. Set the permission level — Can edit or Can view.
5. Add an optional message, then click Send — or copy a link to share manually.

The recipient receives an email with a link. When they open it (in Excel Online or the desktop app, depending on their setup), they'll be working in the same file.

Key Variables That Affect How Sharing Works

Not all sharing experiences are equal. Several factors shape what's possible:

Permissions: Viewer vs. Editor

When you share, you control what others can do. 🔒

• Can edit — the recipient can make changes, add data, modify formatting
• Can view — read-only access; useful for distributing reports without risking accidental changes
• Specific people vs. anyone with the link — a shareable link can be restricted to named individuals or opened to anyone who has it

You can change or revoke permissions at any time through OneDrive or SharePoint's sharing settings.

What Happens When Multiple People Edit at Once

With co-authoring enabled, AutoSave turns on automatically (for cloud-stored files). Changes are synced every few seconds. If two people edit the same cell simultaneously, Excel will flag a conflict and ask which version to keep.

This works smoothly in most cases, but complex workbooks — ones with heavy use of macros, pivot tables, or external data connections — can occasionally behave unpredictably in a multi-user environment. The more complex the workbook, the more worth testing before rolling it out to a team.

Sharing Without Microsoft 365

If you're not on a Microsoft 365 subscription, your options are more limited but not zero:

• Email the file as an attachment — simple, but creates separate copies with no sync
• Google Sheets — if collaboration is the goal and your team is flexible, importing an Excel file into Google Sheets gives you real-time co-editing without a Microsoft subscription 📊
• Dropbox or Google Drive — these can host Excel files and share them, but true co-authoring inside the Excel format typically requires Microsoft's own cloud infrastructure

The Part That Depends on Your Setup

How you should share an Excel file — and whether the result will feel seamless or frustrating — comes down to a combination of your subscription level, where your files live, who you're sharing with, and how technically complex the workbook is. A simple budget tracker shared with two colleagues on Microsoft 365 is a very different situation from a macro-heavy reporting template going out to a mixed group of users on different software versions. The mechanics described here are consistent, but the right configuration is something only your specific situation can answer.