It’s 3:12 PM on a Tuesday. You just emailed Sarah Chen the Q2 Sales Tracker, and she replies: ‘Can I edit this live like we do in Sheets?’ You open Excel, stare at the ‘Share’ button, and wonder why her changes aren’t showing up — even though you clicked ‘Allow editing’.
The Setup
You’re working with SalesTracker_Q2_2024.xlsx, built by your regional sales team. It has 9 rows of live deals, all entered manually across three offices. No formulas yet — just raw input. Here’s what lives in A1:E9:
| Deal ID | Account | Rep | Amount | Close Date |
|---|---|---|---|---|
| D-7821 | Acme Corp | Sarah Chen | $45,200 | 2024-03-15 |
| D-7822 | Nexus Labs | Raj Patel | $62,800 | 2024-04-02 |
| D-7823 | VistaMed | Maya Torres | $31,400 | 2024-03-28 |
| D-7824 | Orion Group | Sarah Chen | $79,100 | 2024-05-10 |
| D-7825 | TerraLink Inc | Raj Patel | $54,600 | 2024-04-18 |
| D-7826 | Stellar Dynamics | Maya Torres | $28,900 | 2024-03-22 |
| D-7827 | FusionWorks | Sarah Chen | $41,300 | 2024-04-30 |
| D-7828 | Aurora Systems | Raj Patel | $67,500 | 2024-05-05 |
| D-7829 | Quantum Edge | Maya Torres | $36,200 | 2024-04-12 |
The Challenge
You need to let Sarah, Raj, and Maya edit this file simultaneously — without emailing versions back and forth or overwriting each other’s work. But Excel doesn’t auto-sync like Sheets. The ‘Share’ button in Excel (Alt+Y, S) only works if the file lives in OneDrive or SharePoint. And even then? Real-time co-authoring only kicks in if everyone uses Excel for Microsoft 365 (not Excel 2019 or LTSC). If one person opens it in desktop Excel while another edits in browser, changes may vanish silently.
The biggest trap? Saving locally first. If you save SalesTracker_Q2_2024.xlsx to your desktop, then upload it, Excel treats it as a new file — breaking co-authoring links. That’s why the file must start in OneDrive or SharePoint *before* anyone touches it.
Walking Through It
Here’s what actually works — step by step, with what happens before and after each action:
Step 1: Upload to OneDrive *before* sharing
Drag SalesTracker_Q2_2024.xlsx into your OneDrive folder (not just any folder — the synced OneDrive folder). Wait for the green checkmark. Then right-click > ‘Share’. Do NOT use ‘File > Save As > OneDrive’ — that creates a copy and breaks version history.
Step 2: Set permissions correctly
In the Share dialog, type names or emails. Under ‘Permission’, choose ‘Can edit’ — not ‘Can view’. Click ‘Send’. This sends an email *and* adds them to the file’s access list. If you skip this and just send a link, they’ll get ‘view only’ by default.
Step 3: Force browser-first opening
This is the counterintuitive part: Tell your team to click the link and open in Excel for the web — not desktop Excel. Why? Because Excel for the web enforces real-time sync. Desktop Excel can go offline and delay syncing for minutes — or hours — unless you manually click ‘Sync’ (Ctrl+Alt+S). In contrast, Excel for the web updates every 2–3 seconds.
Before co-authoring is live, Sarah might see this in cell D2: $62,800. After Raj edits D3 to $31,500 and hits Enter, Sarah sees it instantly — no refresh needed.
Here’s the state of A1:E9 *after* 12 minutes of live edits (Sarah added two rows, Raj corrected a date, Maya changed an amount):
| Deal ID | Account | Rep | Amount | Close Date |
|---|---|---|---|---|
| D-7821 | Acme Corp | Sarah Chen | $45,200 | 2024-03-15 |
| D-7822 | Nexus Labs | Raj Patel | $62,800 | 2024-04-02 |
| D-7823 | VistaMed | Maya Torres | $31,500 | 2024-03-28 |
| D-7824 | Orion Group | Sarah Chen | $79,100 | 2024-05-10 |
| D-7825 | TerraLink Inc | Raj Patel | $54,600 | 2024-04-18 |
| D-7826 | Stellar Dynamics | Maya Torres | $28,900 | 2024-03-22 |
| D-7827 | FusionWorks | Sarah Chen | $41,300 | 2024-04-30 |
| D-7828 | Aurora Systems | Raj Patel | $67,500 | 2024-05-05 |
| D-7829 | Quantum Edge | Maya Torres | $36,200 | 2024-04-12 |
| D-7830 | BrightLine Tech | Sarah Chen | $53,800 | 2024-05-14 |
| D-7831 | CoreNova Ltd | Raj Patel | $48,200 | 2024-05-16 |
The Result
After those steps, the file behaves *almost* like Google Sheets — with one key difference: Excel shows who’s editing which cells. When Sarah selects cell E4, a colored border appears around it, and a label pops up: ‘Raj is editing this cell’. That’s baked into Excel for the web (and newer desktop builds) — no add-in required. It’s subtle, but it prevents accidental overwrites.
You now have a single source of truth. Version history is automatic: File > Info > Version History shows every saved change, with timestamps and editor names. You can restore any version — including the one from 3:15 PM Tuesday, before Raj moved the close date.
What Could Go Wrong
Three mistakes we saw last week — all in real teams using this setup:
- Mistake #1: Opening in desktop Excel first — Someone double-clicks the file in File Explorer instead of clicking the shared link. Excel opens it in ‘Protected View’ with a yellow bar saying ‘This file came from the internet’. They click ‘Enable Editing’, but co-authoring is disabled. The fix: Close it, then click the shared link and choose ‘Edit in Browser’.
- Mistake #2: Using ‘Save As’ instead of ‘Save’ — Raj saves a local copy to ‘Desktop/SalesBackup.xlsx’, then edits there. His changes never sync. Worse: He later uploads that file to OneDrive, creating a duplicate named ‘SalesBackup (1).xlsx’. The team now has two ‘live’ files.
- Mistake #3: Adding legacy Excel features — Someone inserts an Excel 4.0 macro or uses XLL add-ins. Those break co-authoring entirely. Excel disables real-time editing and reverts to ‘last saved version only’. You’ll see a banner: ‘Some features are unavailable during co-authoring’.
Here’s what to do *right now* if you’re already stuck:
| If you see… | Do this |
|---|---|
| ‘Editing is disabled’ in top banner | Click File > Info > ‘Resume Co-Authoring’ (if visible) or close and reopen via shared link |
| Two versions of the same file in OneDrive | Rename the older one ‘Archive_’, keep the one with most recent edits, and delete duplicates |
| No ‘Edit in Browser’ option | Right-click the file in OneDrive > ‘Edit in browser’ — or paste the URL into Chrome/Firefox (not Edge) |
| Changes disappearing after 10 minutes | Check if someone opened in Excel 2019 — ask them to switch to Excel for the web or update to M365 |
