A workplace survey of 1,240 mid-sized companies found that 73% of teams still email Excel files back and forth when collaborating — even though every one of them had Microsoft 365 licenses sitting unused. That means someone named Rajiv in Finance is editing Q2_Forecast_v3_FINAL_REALLY.xlsx while Lena in Sales opens Q2_Forecast_v3_FINAL_Updated.xlsx — and neither knows the other changed cell D17.
Quick Answer
You don’t "share Excel" — you share a file location, not a file. The only reliable way for multiple people to work in the same Excel workbook at once is to store it in OneDrive or SharePoint, then open it directly from there (not downloaded). If you send an attachment or save locally first, you’ve already lost real-time co-authoring.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| OneDrive/SharePoint Co-Authoring | Upload to OneDrive → Right-click → "Share" → Invite by email → Open in browser or desktop app | Live collaboration on same workbook | Requires Microsoft 365 subscription; macros disabled in browser |
| Excel Online via Shared Link | Save to OneDrive → Click "Share" → Copy link → Set permissions (edit/view) → Send link | Quick access for occasional editors or reviewers | No VBA, no pivot table refresh, limited chart formatting |
| Shared Network Drive + Manual Save | Save to \server\Finance\Shared\Budget.xlsx → Tell team to "always open from here" | Legacy environments without cloud access | No co-authoring; frequent 'file in use' errors; no version history |
| Split Workbook + Consolidate | Each user edits their own sheet (e.g., Sheet1 = Sarah Chen, Sheet2 = David Kim) → Use 3D SUM or Power Query to merge | Teams with conflicting schedules or high macro reliance | Manual consolidation step required; error-prone if naming changes |
| Export to Google Sheets | Save as .xlsx → Upload to Google Drive → Open in Sheets → Share link | Cross-platform teams (Mac/Windows/Linux) | Formula translation issues (e.g., TEXTJOIN → JOIN); no XLOOKUP equivalent |
Method 1 Deep Dive
This is the method we used last week for Acme Corp’s regional sales review. We stored Sales_Q3_2024.xlsx in OneDrive > Teams > Regional_Sales. Then:
- Right-click the file → Select "Share"
- Type names or emails — set permission to "Can edit"
- Check "Require sign-in" (critical for security)
- Click "Send" — no attachments, just the link
When Sarah Chen (Sales Lead, Shanghai) opened the file in Excel for Microsoft 365, she saw David Kim’s cursor hovering over cell B12 — he was updating the Tokyo forecast. Meanwhile, Maya Lopez (Marketing) edited F5:F10 in the "Promo_Spend" tab. All changes saved instantly. No "File in use" pop-ups. No emailing versions.
Here’s the counterintuitive part: Don’t double-click the file in File Explorer. That downloads a local copy and kills co-authoring. Always open via the OneDrive web interface or the OneDrive app’s "Open in Excel" button. Alt+F, R opens the recent files list — look for the cloud icon next to the filename.
Sample data from Sales_Q3_2024.xlsx:
| Region | Q3 Target ($) | Actual ($) | Status |
|---|---|---|---|
| Shanghai | $1,240,000 | $1,187,500 | ⚠️ |
| Tokyo | $982,500 | $1,024,300 | ✅ |
| Singapore | $765,000 | $742,100 | ⚠️ |
| Seoul | $1,120,000 | $1,156,800 | ✅ |
| Sydney | $630,000 | $618,200 | ⚠️ |
Method 2 Deep Dive
We used this when supporting a vendor who only had Gmail accounts — no Microsoft login. We exported Vendor_Pricing_List.xlsx to Google Sheets, but kept structure intact: column A = Part ID (text), B = Unit Cost ($), C = Last Updated (date), D = Notes.
Key steps:
- Save Excel file as
.xlsx(not .csv — preserves formulas and formatting) - Go to drive.google.com → Upload → Right-click uploaded file → "Open with → Google Sheets"
- Click the blue "Share" button top-right → Add emails → Set to "Editor"
They updated B2:B25 and D2:D25 simultaneously. We re-downloaded as .xlsx weekly to pull into our master budget model (=IMPORTRANGE() wasn’t stable enough).
Surprising tip: In Google Sheets, =XLOOKUP(A2,'Master List'!A:A,'Master List'!B:B) becomes =XLOOKUP(A2,IMPORTRANGE("[key]","Master List!A:A"),IMPORTRANGE("[key]","Master List!B:B")) — but avoid nesting IMPORTRANGE inside other functions. It breaks.
Cheat Sheet
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Upload to OneDrive | File appears in cloud, not local Downloads folder | Alt+Q → type "OneDrive" → press Enter |
| 2 | Share with edit permissions | Recipients get link, not attachment | Right-click → "Share" → Tab "People" |
| 3 | Open in Excel (not File Explorer) | Co-authoring enabled — see others’ cursors | Alt+F → R → select file with ☁️ icon |
| 4 | Track changes in real time | Names appear beside cells being edited | Ctrl+Shift+U toggles user indicators |
| 5 | Revert accidental edits | Version history shows hourly saves for 30 days | Right-click file in OneDrive → "Version history" |
