Limits of Offline Excel Sharing No Live Cursors and the Refresh Delay
The first day on a shared workbook, someone always asks the same question: 'I cannot see Ramesh typing — is it broken?' It is not broken. It is a turn-based system wearing a collaboration costume, and once the whole team understands its rhythm, the complaints stop and the system quietly works.
✍️ Technical Anshu🪟 Windows 10 / 11⏱️ 7 minute read
🎥 Watch the full video — offline Excel collaboration set up step by step on a local network
The video is honest about this and this page repeats the honesty in full: offline shared workbooks do not update live. There is no server watching keystrokes and painting them on other screens, because there is no server at all — just a file on a share and Excel copies politely taking turns to write to it. Everything users notice — the refresh delay, the conflict dialog, the colleague whose changes 'suddenly appeared' — is that one design fact wearing different clothes.
The journey of one change in an offline shared workbook
1 — You type the entryOnly your screen sees it
2 — You press Ctrl + SYour change is written to the shared file
3 — The file on the shareNow holds everyone's saved work
4 — Colleague saves, or their timed update runsTheir screen pulls your change in
Total delaySECONDS TO MINUTES — NEVER INSTANT
Compare this with cloud co-authoring, where a live server pushes each keystroke in under a second. Offline sharing replaces that server with the save button — yours and theirs.
1
Why There Are No Live Cursors
Live cursors need a referee: a program that receives everyone's edits continuously, orders them, and broadcasts the result. In cloud tools that referee is the provider's server. On your LAN there is only a file, and a file cannot referee — it can only be written and read. So desktop Excel offline does the next best thing: each save is a merge, where your changes go in and everyone else's saved changes come back to you. Collaboration happens, just in turns measured by saves.
2
Tuning the Refresh — The Advanced Tab Settings
Share Workbook's Advanced tab holds the two settings that decide how stale a screen can get, and most offices never look at them.
Update changes: choose 'when file is saved' for merges driven by your own saves, or 'automatically every' few minutes for a timed pull — 5 to 15 minutes suits most registers
Shorter intervals freshen screens faster but interrupt work with merges more often on a busy file
Conflicting changes between users: 'Ask me which changes win' is the setting that produces the resolve dialog; the alternative silently lets the later save win, which hides data loss — leave it on Ask
Include in personal view: print settings and filters per user keep one person's filter view from rearranging everyone else's screen
3
The Same-Cell Conflict — What Actually Happens
The system's one true collision: two people change the same cell in the same save interval. Excel cannot average two prices, so it asks.
The first saver wins silently — their value is already in the file
The second saver gets the Resolve Conflicts dialog showing both values, cell by cell
They choose Accept Mine or Accept Other for each; the rejected value is discarded, not stored anywhere for later regret
Different cells, even in the same row, never conflict — which is why dividing territory by rows or sheets makes conflicts rare
4
Working Comfortably Inside the Limits
Teams that thrive on offline sharing share three habits, none of them technical.
Save like you mean it:Ctrl + S after each small batch of entries, not once at closing time — your save is your colleagues' refresh
Announce big edits: 'I am restructuring the totals row' in the room or the group chat prevents five minutes of mutual surprise
Match the tool to the pace: a stock register updated through the day fits turn-based sharing perfectly; a live auction sheet the whole room watches does not — that one needs true co-authoring
🔴 The delay is a property, not a malfunction. Reinstalling Excel, 'fixing' the network and restarting PCs will never make an offline shared workbook live, because nothing is wrong. If the team genuinely needs to watch each other type, the answer is a different tool — not a repair of this one.
🎥 Watch the Refresh Rhythm in the Video
In the demonstration you can see a change saved on one PC appear on the other only after the merge — exactly the rhythm this page describes.
Little and often wins: save after each entry or small batch, roughly every few minutes while actively working. Every save both publishes your changes and pulls in everyone else's, so frequent saving keeps all screens fresh and keeps conflicts small and rare. Saving once at the end of the day creates one giant merge and the worst conflict dialogs.
Can I see who else is in the file right now
Yes, within limits. The Editing tab of the Share Workbook dialog lists the users who currently have the workbook open, by the user name set in their Excel options. It is a snapshot, not a live presence panel — there are no cursor positions or 'typing now' indicators, because the system has no live channel to show them through.
What happens if the network drops while I am editing
Your copy keeps working locally in memory, but saves fail until the connection returns — and Excel will tell you the save did not complete. Do not close the file in a panic. Restore the connection, save again, and your merge proceeds. If Excel was closed or crashed mid-outage, reopen from the share, check the last entries against your notes, and re-enter only what is missing.
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 🙏