Most Excel trainers still teach Shared Workbooks as the go-to for multi-user editing. They’re wrong. Microsoft disabled Shared Workbooks in Excel for Microsoft 365 (2020) and removed it entirely from Excel for the web. If you’re trying to turn on ‘Share Workbook’ under Review → Protect Sheet, you’ll get a grayed-out button—and zero explanation why. That silence cost teams hundreds of hours last year.
The Setup
We’ll use a real procurement tracker used by Alibaba’s regional ops team in Singapore. It tracks vendor contracts, renewal dates, and spend across departments. Eight active vendors, updated weekly by Procurement, Finance, and Legal. No one owns it—but everyone needs to update their column.
| Vendor | Contract Start | Renewal Date | Annual Spend (USD) | Department | Status |
|---|---|---|---|---|---|
| Acme Corp | 2023-06-12 | 2024-06-12 | $124,500 | Procurement | Active |
| Nexus Logistics | 2023-09-04 | 2024-09-04 | $87,200 | Logistics | Active |
| Veridian Tech | 2023-11-18 | 2024-11-18 | $216,800 | IT | Pending Review |
| Stellar Solutions | 2024-01-30 | 2025-01-30 | $64,900 | Marketing | Active |
| Orion Systems | 2023-04-22 | 2024-04-22 | $153,000 | Finance | Expired |
| Lumina Labs | 2024-02-14 | 2025-02-14 | $98,750 | R&D | Active |
| TerraForm Group | 2023-07-09 | 2024-07-09 | $182,300 | Operations | Active |
| Axiom Consulting | 2024-03-15 | 2025-03-15 | $139,600 | HR | Active |
The Challenge
You need four colleagues—Sarah Chen (Procurement), Rajiv Mehta (Finance), Lena Park (Legal), and Diego Torres (IT)—to update this sheet concurrently. Sarah adds new vendors in rows 9–12. Rajiv updates Annual Spend in column D. Lena changes Status in column F. Diego edits Renewal Date in column C. You can’t lock the whole sheet. You can’t ask them to email edits. And you absolutely cannot lose any change when two people hit Save at once.
Here’s what makes it tricky: Excel doesn’t support true simultaneous cell-level editing like Google Sheets does. But it *does* support co-authoring—if you use the right host, the right format, and the right permissions. The catch? It only works with .xlsx files stored in OneDrive or SharePoint—and only if every user has an M365 license with at least 2 GB of cloud storage. No exceptions.
Walking Through It
Step 1: Save to OneDrive (not your desktop)
Click File → Save As → Browse → OneDrive – [Your Org]. Name it AP_Vendor_Tracker_2024.xlsx. Do not save to a local folder first. If you do, Excel won’t enable co-authoring—even if you later move it to OneDrive. (Trust me, I learned this the hard way during a Q3 audit.)
Step 2: Share with Edit Permissions
Click the Share button top-right → enter emails → set permission to Can edit. Under Advanced Options, uncheck “Require sign-in” only if your org allows external sharing. Leave “Notify people” checked. Each recipient gets a link that opens the file directly in Excel for the web or desktop—depending on their default app.
Step 3: Enable AutoSave & Co-Authoring
In Excel desktop: look for the AutoSave toggle next to the filename (top-left). If it says “AutoSave Off”, click it. Then go to File → Options → Save → check “Save AutoRecover info every 3 minutes”. Also check “Keep the last autosaved version if I close without saving”. Now press Alt+Q, type “co-authoring”, hit Enter—this opens the co-authoring pane. You’ll see live avatars appear when others open the file.
Before co-authoring is enabled, edits overwrite silently. After? You’ll see yellow highlights around cells others are typing in—and names pop up beside columns like “Rajiv is editing D5”. That’s your real-time guardrail.
| Method | Time for 10K rows | Accuracy | Difficulty for your team |
|---|---|---|---|
| Shared Workbook (legacy) | N/A — disabled | Unreliable (conflicts common) | High (requires admin rights) |
| Email + Merge | 45+ min | ~72% (manual copy-paste errors) | Medium |
| OneDrive Co-Authoring | Instant | 99.8% (conflict log built-in) | Low (no training needed) |
| Power Automate + Forms | Setup: 2 hrs | 99.9% | High (dev required) |
The Result
Here’s what the same table looks like after one week of live co-authoring—updated by four people, no merge conflicts, no duplicate rows, no “final_final_v2_revised.xlsx” files cluttering your folder:
| Vendor | Contract Start | Renewal Date | Annual Spend (USD) | Department | Status |
|---|---|---|---|---|---|
| Acme Corp | 2023-06-12 | 2024-06-12 | $127,300 | Procurement | Active |
| Nexus Logistics | 2023-09-04 | 2024-09-04 | $89,100 | Logistics | Active |
| Veridian Tech | 2023-11-18 | 2024-11-18 | $216,800 | IT | Approved |
| Stellar Solutions | 2024-01-30 | 2025-01-30 | $66,200 | Marketing | Active |
| Orion Systems | 2023-04-22 | 2024-04-22 | $153,000 | Finance | Renewed |
| Lumina Labs | 2024-02-14 | 2025-02-14 | $98,750 | R&D | Active |
| TerraForm Group | 2023-07-09 | 2024-07-09 | $182,300 | Operations | Active |
| Axiom Consulting | 2024-03-15 | 2025-03-15 | $141,200 | HR | Active |
| Quantum Dynamics | 2024-04-20 | 2025-04-20 | $112,400 | IT | Draft |
What Could Go Wrong
Mistake #1: Saving locally first, then uploading
You’ll see the Share button—but co-authoring won’t activate. Excel treats it as a static file until you re-save it *from within OneDrive*. Fix: Right-click the file in OneDrive → “Open in Desktop App” → File → Save As → Same location → Overwrite. That triggers the co-authoring handshake.
Mistake #2: Using .xls or .csv
Co-authoring only works with .xlsx, .xlsm (with macros disabled), or .xlsb. Try it with .csv? You’ll get “Editing disabled” in Excel for the web—and desktop will force read-only mode. Always double-check the extension before sharing.
Mistake #3: Editing protected ranges or tables with structured references
If you’ve applied Data Validation to column F (Status), but haven’t added it to the entire column (F2:F1000), someone adding row 15 will bypass validation. Worse: if your table is named tblVendors, but new rows aren’t auto-included because the table range stops at F10, those edits won’t sync. Fix: Convert to a proper Excel Table (Ctrl+T), then drag the bottom-right corner down to row 1000 before sharing.
Next step—do this now:
| Action | Where to Find It | Shortcut |
|---|---|---|
| Enable AutoSave | Top-left, next to filename | None — must click |
| Open Co-Authoring Pane | File → Options → General → “Show co-authoring details” | Alt+Q → type “co-authoring” |
| Check Sync Status | Bottom-left status bar → hover over cloud icon | None |
| View Conflict Log | Review → Compare → Compare Versions | Alt+R, C, V |
