Why does your colleague get ‘Access Denied’ when you send a link? Why does Excel say ‘This workbook is locked for editing’ even though no one’s in it? Why does version history show changes from someone who swears they never opened the file?
Quick Answer
To make an Excel doc shared: save it to OneDrive or SharePoint first, then use File > Share > Invite people (with edit rights), or right-click the file in OneDrive/SharePoint and select Share. Never email the .xlsx file and expect real-time collaboration — that’s not sharing, that’s file-passing.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| OneDrive Share Link | Save to OneDrive → Right-click → Share → Set permission (Can edit) → Copy link | Teams, quick external sharing, ad-hoc collaboration | Link expires if admin disables external sharing; no granular cell-level control |
| SharePoint Library Sharing | Upload to SharePoint → Select file → Click Share → Choose people → Assign roles (Edit/View) | Enterprise teams, compliance-heavy orgs, audit trails | Requires SharePoint license; permissions inherit from folder unless broken |
| Co-Authoring via Excel Online | Open in browser → Click Share → Paste email → Set ‘Can edit’ → Send | Real-time editing with live cursors, comments, presence indicators | Desktop app must be closed first; autosave required; no VBA support online |
| Shared Workbook (Legacy) | Review tab → Share Workbook → Check ‘Allow changes by multiple users’ → Save to network location | Older Windows networks, no cloud access, local file servers | Deprecated since Excel 365; breaks with tables, pivot caches, most formulas; no conflict resolution |
| Microsoft 365 Group Folder | Save to Files tab in Outlook/Teams group → Share via group membership → Edit permissions in group settings | Ongoing team projects tied to Teams channels or Outlook groups | Group must exist first; members auto-inherit access; no guest user override without admin |
| Email Attachment + Track Changes | File → Send → Email as Attachment → Ask recipients to return edited copies | One-way feedback, legal redlines, offline-only environments | No version merging; no real-time sync; impossible to reconcile 7 emailed copies named ‘Final_v3_John_edits_FINAL.xlsx’ |
Method 1 Deep Dive
Let’s walk through OneDrive sharing — the method 92% of small teams actually use, and where 70% of permission failures happen.
Open your workbook. Go to File → Save As → Browse. In the dialog, navigate to your OneDrive folder (not your Desktop). Save as Sales_Q3_Forecast_2024.xlsx in OneDrive - Acme Corp\Finance\Q3 Planning.
Now — don’t close Excel. Open File Explorer. Navigate to that same folder. Right-click the file. Select Share. A pane opens on the right.
Click Specific people. Type sarah.chen@acmecorp.com and mike.tan@acmecorp.com. Under Permission, pick Can edit. Uncheck Require sign-in only if your org allows it (most don’t — leave it checked).
Click Send. They’ll get an email with a direct link to the file in Excel Online.
Here’s what most people miss: If Sarah opens the file in Excel desktop while Mike is editing online, her copy becomes a *local snapshot*. She won’t see his edits until she closes and reopens — or presses Alt+R+E (Refresh from OneDrive). That’s the counterintuitive part: Excel desktop doesn’t auto-sync edits from the cloud unless you force it.
Test it: Have Mike change cell B5 from $42,800 to $45,200 in the online version. Sarah’s desktop shows $42,800 until she hits Alt+R+E — then B5 updates instantly.
Sample data in this workbook:
| Region | Q3 Forecast ($) | Owner | Last Updated |
|---|---|---|---|
| North America | $214,500 | Sarah Chen | 2024-07-12 |
| EMEA | $189,300 | Mike Tan | 2024-07-11 |
| APAC | $156,700 | Priya Desai | 2024-07-10 |
| LATAM | $98,200 | Diego Mora | 2024-07-09 |
| Total | $658,700 | — | — |
Method 2 Deep Dive
SharePoint is the enterprise-grade option — and where permissions get messy fast. Let’s fix that.
Go to your team’s SharePoint site (e.g., https://acmecorp.sharepoint.com/sites/finance-team). Click Documents in the left nav. Click Upload → Files. Select your Sales_Q3_Forecast_2024.xlsx.
Once uploaded, hover over the filename. Click the ⋯ (more options) icon → Share.
Type finance-team@acmecorp.com. Set permission to Edit. Click Apply. Done? Not yet.
Here’s the trap: SharePoint applies permissions at the folder level by default. If you later upload Q3_Budget.xlsx to the same folder, it inherits the same access — even if only two people should see it.
To isolate permissions: Hover again → ⋯ → Manage access → Advanced → Stop inheriting permissions. Now you can assign unique permissions per file.
Now test co-authoring. Open the file directly in Excel Online (click the filename, not Download). You’ll see live avatars in the top-right corner. When Mike types in cell C8, Sarah sees his cursor blink beside “Priya Desai”. No delay. No refresh needed.
But — and this is critical — if Sarah opens the same file from her desktop Excel app using the SharePoint path (https://acmecorp.sharepoint.com/sites/finance-team/Shared%20Documents/Sales_Q3_Forecast_2024.xlsx), she gets a read-only warning unless she clicks Enable Editing and confirms she wants to work offline. Don’t do that. Tell her to click Open in Excel from the browser tab instead — that launches the desktop app *connected* to SharePoint.
That single click difference decides whether edits sync or vanish.
Cheat Sheet
| Action | Where | Shortcut / Path | Notes |
|---|---|---|---|
| Save to OneDrive | File tab | File → Save As → OneDrive - Acme Corp | Never save to Desktop or Downloads first |
| Refresh cloud version in desktop Excel | Review tab or ribbon | Alt+R+E | Critical after others edit online |
| Share via SharePoint | SharePoint web interface | ⋯ → Share → Type name → Edit | Always verify ‘Edit’ is selected — not ‘View’ |
| Open SharePoint file in connected desktop Excel | Excel Online tab | Click ‘Open in Excel’ (not ‘Download a copy’) | ‘Download’ = offline = no sync |
| Check who’s editing now | Top-right corner | Look for profile initials or avatars | Only visible in Excel Online or synced desktop |
| Revoke access instantly | OneDrive/SharePoint share pane | Manage access → Find person → ⋯ → Remove access | Takes effect in <30 seconds |
| See version history | File tab | File → Info → Version History | Shows who changed what, and when — even deleted rows |
