Why does your colleague’s edit disappear when you save? Why does Excel say ‘file locked’ even though no one’s online? Why does the version history show edits from Tuesday — but nobody opened it then?
Quick Answer
No — not in desktop Excel alone. Yes — only when using Excel for Microsoft 365 with files stored in OneDrive or SharePoint, and only if everyone uses the web app or modern desktop client with co-authoring enabled. Local .xlsx files on a network drive? No real-time collaboration — just turn-taking and silent overwrites.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Excel for Microsoft 365 + OneDrive/SharePoint | Save file to OneDrive or SharePoint → Open in Excel (desktop or web) → Others open same link → Edits appear live | Teams updating budgets, sales forecasts, project trackers | Requires M365 license; macros, add-ins, legacy features disabled in web |
| Shared Workbook (Legacy) | Review tab → Share Workbook → Check ‘Allow changes by multiple users’ → Save to network location | Older Excel versions; no cloud access | Removed in Excel 365 (v2308+); no cell-level tracking; no conflict resolution |
| Excel Online via SharePoint | Upload to SharePoint document library → Click file → Open in Excel Online → Invite via Share button | Light editing, quick reviews, remote clients without licenses | No VBA, no Power Query refresh, limited chart formatting |
| Power BI + Excel Data Model | Publish Excel data model to Power BI Service → Build reports → Use Excel as read-only viewer | Centralized source of truth with live dashboards | No direct cell editing in Excel — edits must happen upstream (e.g., in Dataverse or SQL) |
| Manual merge with version control | Each user saves local copy → Name with initials + date (e.g., Budget_JL_2024-03-15.xlsx) → One person consolidates manually | High-risk data (HR salaries, legal docs), auditable workflows | Zero automation; error-prone; no live sync; requires discipline |
Method 1 Deep Dive
Use Excel for Microsoft 365 + OneDrive. This is the only method that delivers true co-authoring — where Sarah Chen sees Alex Rivera’s cursor in cell D7 while he types “$42,800”.
Start here: Open your file. Go to File → Save As → OneDrive – Acme Corp. Name it “Q2_Sales_Forecast.xlsx”. Click Save.
Now — critical step — close Excel. Reopen the file by clicking the link in the OneDrive folder, not by browsing to the local download cache. That ensures you load the cloud-hosted version.
Invite others: Right-click the file in OneDrive → Share → Enter emails → Set permission to “Can edit”. They’ll get a link that opens in Excel Online by default — but if they have Excel desktop installed and signed in with the same M365 account, it launches there instead.
Here’s what happens live:
| A | B | C | D |
|---|---|---|---|
| Region | Product | Forecast Q2 | Last Updated |
| APAC | CloudSuite Pro | $189,500 | 2024-03-15 14:22 |
| EMEA | CloudSuite Pro | $214,100 | 2024-03-15 14:22 |
Alex changes D2 to “2024-03-15 14:27”. Sarah sees the timestamp update instantly. She adds a new row at A5: “Americas”, “CloudSuite Lite”, “$94,200”. The change appears for Alex within 2 seconds — no refresh needed.
Surprising tip: If co-authoring stops working, don’t restart Excel. Press Alt+X, R, R — that’s the hidden “Refresh Co-Authoring Session” shortcut. It forces a re-sync without closing the file.
Method 2 Deep Dive
Shared Workbook is obsolete — but some finance teams still try to use it. Don’t. Here’s why it fails silently.
Imagine you enable Shared Workbook (Review → Share Workbook → check box). You save to \\server\finance\budgets\. Then three people open it. What you don’t see: Excel doesn’t lock cells. It lets everyone type anywhere. When User 1 saves, Excel merges changes — but if User 2 changed the same cell 2 minutes earlier, their edit vanishes. No warning. No log. Just gone.
Worse: The ‘Track Changes’ log shows “User1 edited B5 at 10:03” — but never says “User2 also edited B5 at 10:01 and was overwritten.”
Real-world example: In June 2023, a procurement team at Veridian Logistics used Shared Workbook for vendor pricing. Two buyers updated Unit Cost in column C. One entry ($12.40) survived. The other ($11.95) disappeared. They discovered it only after a $14,700 overpayment — because the audit trail didn’t capture the loss.
If you’re stuck with this method (legacy systems, no M365), do this: Disable all formulas in shared zones. Use only static values. And run Alt+T, G, T daily — that opens the ‘Compare Side by Side’ tool — to manually spot mismatches between local copies and the server version.
Cheat Sheet
| Action | Shortcut / Steps | Notes |
|---|---|---|
| Force co-authoring refresh | Alt+X, R, R | Works only in Excel for M365, not Excel Online |
| Check who’s editing now | Top-right corner → Names appear beside ‘Editing’ icon | Click name to see their cursor location (e.g., “Alex is editing D7”) |
| Revert to last known good version | File → Info → Version History → Select timestamp → Restore | Versions saved every 10 minutes automatically (M365 only) |
| Open in desktop (not browser) | In Excel Online → File → Open in Desktop App | Only works if user has Excel installed and M365 license |
| Disable auto-save (if needed) | File → Options → Save → Uncheck ‘Save AutoRecover info every X minutes’ | Use only during sensitive merges — re-enable immediately after |
