What Most People Miss About How Multiple Users Edit Excel

Yes, multiple people can edit the same Excel file at once—but only if you’re using Excel for Microsoft 365 on a cloud-hosted workbook. If you’ve ever sent an XLSX via email and told three colleagues to 'just update it', you’ve unknowingly created a version-control disaster.

Quick Answer

You can enable real-time co-editing in Excel only when the file lives in OneDrive or SharePoint, is opened in Excel for Microsoft 365 (not Excel 2019 or LTSC), and all editors have edit permissions—no local network shares, no Dropbox sync folders, no USB drives.

All the Methods

Method	Steps	Best For	Limitations
OneDrive Co-Authoring	Upload to OneDrive > Open in Excel Online or desktop app > Share link with edit rights	Teams updating sales forecasts or HR tracking candidate status	Fails if opened from File Explorer instead of browser or app; no support for macros or Power Query refresh
SharePoint Document Library	Save to SharePoint site > Set permissions > Open via 'Open in Excel' button	Finance teams reconciling monthly P&L across regions	Requires SharePoint license; column-level permissions don’t apply to Excel cells
Excel Online Only	Open file in browser > Click 'Edit Workbook' > 'Edit in Browser'	Quick edits during virtual standups or client calls	No VBA, no pivot table drill-downs, no Solver, no custom number formats beyond basics
Shared Network Drive + Manual Merge	Save copy to \server\finance\Q3-budget > Each person edits their own version > One person merges manually	Organizations stuck on Excel 2016 or without M365 licenses	Zero conflict detection; overwritten changes are silent and irreversible

Method 1 Deep Dive

Let’s walk through OneDrive co-authoring—the only method that gives true simultaneous editing. Start with this sample file: Sales-Tracker-Q3-2024.xlsx, saved in your OneDrive root. It has columns A:E — Account Name (A2:A11), Rep (B2:B11), Q3 Forecast ($) (C2:C11), Last Updated (D2:D11), Status (E2:E11). Open the file directly from OneDrive.com—not from File Explorer. Click the ••• menu > Open in Excel. Now share: click Share top-right > enter Sarah Chen ([e-mail]) and Rajiv Patel ([e-mail]) > set permission to Can edit. Both get live notifications. Here’s the counterintuitive part: if Sarah opens the file from her local Downloads folder—even if it’s synced—co-authoring breaks. She must open it from the OneDrive web interface or the Excel desktop app’s Recent list under "OneDrive - Acme Corp". You’ll see colored initials appear next to cells being edited: Sarah’s “SC” floats over C5 while she types $127,500; Rajiv’s “RP” hovers over E7 as he changes Pending to Committed. No save prompts. No lockouts. But watch cell D2:D11. Those Last Updated timestamps won’t auto-populate unless you add this formula in D2 and drag down: =IF(C2<>"",TEXT(NOW(),"yyyy-mm-dd hh:mm"),""). Excel doesn’t auto-refresh NOW() during co-editing—it only recalculates when the sheet is reloaded or manually forced (F9). That’s why most teams miss audit trails.

Method 2 Deep Dive

SharePoint is stronger for governance but trickier to set up right. Say your file lives at https://acmecorp.sharepoint.com/sites/finance/Shared%20Documents/Budget-2024.xlsx. Don’t double-click it from File Explorer. Instead: go to the SharePoint page > hover over the filename > click the ⋯ > choose Open in Excel (not “Edit in Browser”). Permissions matter more here. Go to the file > Manage Access > ensure both Sarah and Rajiv are in the Members group—not just Visitors. Then test: Sarah edits B4 (changing “Alex Rivera” to “Maya Lin”) while Rajiv edits C8 (typing $89,200). You’ll see real-time presence indicators in the top-right corner: “Sarah Chen editing Sheet1”, “Rajiv Patel editing Sheet1”. Now try something unexpected: delete row 6. Both users see the row vanish instantly—but if Rajiv had been typing in C6 just before deletion, his input goes into C5. Excel shifts content, not just rows. This catches people off guard during live budget reviews. Also: if your workbook uses external data connections (say, pulling from Azure SQL via Power Query), those won’t refresh during co-editing—even with “Refresh data when opening the file” checked. You must close and reopen, or run Alt+A+R+A (Data tab > Refresh All) after everyone stops editing.

Cheat Sheet

Action	How To	Shortcut	Notes
Start co-editing	Open from OneDrive/SharePoint web > Click 'Open in Excel'	None — avoid File Explorer entirely	Opening from local sync folder disables co-authoring
See who’s editing	Look top-right corner > click user avatars	Alt+Q, type 'presence'	Shows active sheets and last edit time
Force recalculation	Select any cell > press F9	F9	Critical for NOW(), TODAY(), and volatile formulas
Refresh external data	Data tab > Refresh All	Alt+A+R+A	Does NOT work mid-co-edit; wait until others pause
Revert accidental edit	File > Info > Version History > Restore previous version	Alt+F+I+V	Versions saved every 5–10 minutes automatically