Offline Excel Collaboration on a Local Network Routes That Work
Your billing clerk, your stock keeper and you all need the same Excel register — and there is no internet worth the name in the office. The installed Excel on your PCs has no live collaboration button at all. This guide sets up the route that actually exists: one file on a network share, edited by everyone through the shared workbook feature.
✍️ Technical Anshu🪟 Windows 10 / 11⏱️ 10 minute read
🎥 Watch the full video — offline Excel collaboration set up step by step on a local network
Here is the fact the whole guide is built on, stated plainly because the video states it plainly too: the desktop version of Excel cannot do real-time collaboration. There are no live cursors and no character-by-character updates in the installed program — that ability lives in Excel for the web, Google Sheets, or a self-hosted setup like Nextcloud with OnlyOffice. What desktop Excel can do, and what the video demonstrates, is a solid workaround: keep one workbook on a shared folder, turn on the legacy Share Workbook feature, and let every PC open and edit that same file. Your teammates see your changes after you save and their copy refreshes — not live, but genuinely shared, with no internet and no cloud account. Set it up in the order below and it serves a small office well.
What offline shared workbooks can and cannot do
See a colleague typing live, character by characterNO
Many PCs edit one file kept on a network shareYes
See changes after the other person saves and your copy updatesYes
Two people edit the same cell in the same minuteCONFLICT DIALOG
Works with the internet fully disconnectedYes
Excel Tables, merged cells and new charts inside the shared fileBLOCKED
The honest scorecard before you start: a shared workbook is turn-based editing on one file, not live co-authoring — and for registers and data entry that is usually enough.
1
Step 1 — Keep One Master File on a Shared Folder
Collaboration fails before it starts when the file lives on someone's desktop and travels by pendrive. Pick one PC that stays on during office hours — or better, a NAS — and make it the permanent home of the workbook.
Create a folder on the host PC, for example D:\OfficeShare, and put the workbook inside it
Right-click the folder → Properties → Sharing tab → Advanced Sharing → tick Share this folder
Click Permissions and give the office users Change access — read-only users can look but never save
On every other PC, open the file through its network path, for example \\OFFICE-PC\OfficeShare\Sales.xlsx — never through a copy saved locally
Pin a shortcut to that network path on each desktop so nobody is tempted to keep a private copy
2
Step 2 — Turn On Share Workbook in Excel
The feature is old, still present in desktop Excel, and hidden in newer versions because Microsoft now pushes cloud co-authoring. First the file must be in the modern format and free of blocked features — no Excel Table objects and no merged cells that matter.
Open the master workbook on the host PC
Go to the Review tab and click Share Workbook — if the button is missing, add it once: File > Options > Quick Access Toolbar > All Commands > Share Workbook (Legacy)
On the Editing tab, tick Allow changes by more than one user at the same time
On the Advanced tab, set Track changes history to keep for 30 days and choose how often updates arrive — the practical choice is when the file is saved
Save the file. Its title bar now shows [Shared] — that word is your proof the mode is on
3
Step 3 — Everyone Opens the Same File, Not Copies
From now on the rule is absolute: there is exactly one workbook. Every PC opens it from the share, edits, and saves back to the same place. The moment someone chooses Save As to their own desktop, the team has two diverging files and a merging headache later.
Open the workbook from the network path on each PC and confirm the title bar shows [Shared] everywhere
Set each person's real name in File > Options > General > User name — change history and conflict dialogs use this name
Work normally: type, edit and press Ctrl + S often — saving is the moment your changes travel to the file
When you save, Excel pulls in everyone else's saved changes at the same time, so a save is also a refresh
4
Step 4 — Learn the Rhythm — Save, Refresh, Resolve
Offline sharing works on a rhythm rather than in real time. You will not see a colleague's half-typed row. You see their work after they save and your copy updates. If two people edit the same cell before either saves, the second saver gets a Resolve Conflicts dialog and picks which value survives — that is by design, not a fault.
Save every few minutes while entering data — small, frequent saves merge cleanly
If the conflict dialog appears, read both values before choosing Accept Mine or Accept Other — the losing value is gone
Agree on territory where you can: one person per sheet, or one person per day's rows, removes most conflicts before they happen
Close the file when you finish — an idle open copy holds the file in a live session on the host for no reason
5
Step 5 — Know the Limits Before They Surprise You
A shared workbook is a dependable tool inside a fence. Outside the fence it frustrates people, so know the boundaries on day one.
Not real time: no live cursors, no instant updates — changes move at save speed, as the video itself says honestly
Blocked features: in shared mode you cannot create Excel Tables, merge or unmerge cells, add conditional formatting or data validation, delete worksheets, or build PivotCharts
File grows: the change history lives inside the file, so a busy workbook slowly bloats — the companion guides on this page cover the hygiene
Graduation exists: when the team needs true live editing, the honest next steps are the ones named in the video — Excel for the web, Google Sheets, or your own Nextcloud with OnlyOffice on the same LAN
🔴 One master file, one location. Every offline Excel disaster story — lost sales, double stock entries, three different totals — starts with the file being copied to a second PC. Keep exactly one workbook on the share, back that one up daily, and treat every other copy as disposable.
🎥 Watch the Complete Offline Sharing Setup
The full demonstration — sharing the folder, enabling the shared workbook and two PCs editing together — is shown live in the video.
Can two people edit the same Excel file offline at the same time
Yes, with the legacy Share Workbook feature and the file kept on a network share, several PCs can have the workbook open and edit it together without any internet. The honest difference from cloud tools is timing: nobody sees live typing. Your changes reach colleagues when you save, and their Excel pulls them in on its next save or scheduled update.
Why is the Share Workbook button missing in my Excel
Microsoft hides the legacy sharing buttons in newer Excel versions because it promotes OneDrive and SharePoint co-authoring instead. The feature itself still exists in desktop Excel. Add it back through File, Options, Quick Access Toolbar, choose All Commands, and add Share Workbook (Legacy) and its companion buttons such as Track Changes and Protect Shared Workbook.
Is a shared workbook the same as Google Sheets live editing
No. Google Sheets and Excel for the web show every editor's cursor and update the sheet as people type, because a server coordinates the session live. An offline shared workbook merges saved changes in turns. For data-entry registers in a small office that difference rarely matters; for a fast-moving sheet everyone watches at once, it does — and live co-authoring is the right tool there.
This guide follows the offline Excel collaboration method in the Technical Anshu video above • Stuck on a step? Ask in the video comments and the community will help 🙏