Help for owners
Staff keep overwriting each other's work in a shared Google Sheet
Short answer
In a shared sheet, anyone with edit access can overwrite any cell, and a sheet cannot say who owns a record. Use version history and cell edit history to trace the damage, protect ranges so each person edits their own area, and give each task its own tab or file.
Does this sound like your situation?
- Someone's entry disappeared and nobody remembers deleting it.
- Two people updated the same row and one version won.
- Nobody knows who last changed a price or a status.
- People keep their own copies 'to be safe'.
- Sorting or filtering by one person confuses everyone else.
Why does this happen?
Everyone with edit access can change everything
Google's roles are Editor, Commenter and Viewer. An editor can make changes to the spreadsheet, so a shared sheet has no built-in notion of one person owning one record.
Confirmed by support.google.com
No areas are protected
Google lets owners and editors protect a sheet or a range, choose who may edit it, or show a warning that must be confirmed first. If this was never set, nothing separates one person's rows from another's.
Confirmed by support.google.com
Shared sorting and filtering
Sorting a range or deleting rows changes the file for everyone. A change that is harmless for one person can scramble another person's work.
Tracing the change is limited
Version history shows who changed what, and cell edit history shows previous values, but Google says some changes do not appear, including added or deleted rows and columns and changes made by formulas.
Confirmed by support.google.com
One sheet doing several jobs
When one tab is used for data entry, review and reporting by different people, collisions are expected.
What can I do about it today?
- Find the lost data firstOpen version history, look at earlier versions and copy back what was lost. Make a copy of a good version rather than restoring over the current one, since restoring clears the earlier cell-by-cell history.
- Right-click a doubtful cellChoose Show edit history to see previous values and who changed them.
- Give each person an areaProtect ranges so each person or team can edit only theirs. Choose the warning option first if people need time to adjust.
- Use views for sortingAsk people to use the filter views feature or a separate copy for their own sorting, not the shared one.
- Review who has edit accessOpen Share and change people who only need to look to Viewer. Removing edit access is reversible.
When should I bring someone in?
- Lost data cost you money or a customer.
- More than a handful of people must enter data at the same time.
- You need an audit trail of every change.
How do I handle it?
- Observe how people actually workI look at who enters what, when, and where collisions occur.
- Restructure the sheetEntry, calculation and reporting are separated, with one row per record and one owner per area.
- Protect and logRanges are protected by role, and a change log is kept for the critical fields.
- Replace the entry step with a formEntries go through a form that adds a new row each time, which removes most overwriting.
- Move to software if it keeps growingWhen many people edit the same records, a small application with accounts and a change history is the lasting fix.
The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.
What do owners ask about this?
Can I stop people overwriting without blocking them?
Yes. Protection can be set to show a warning that must be confirmed, which slows accidents without locking anyone out.
Can I see everything that ever changed?
Not completely. Google lists some changes, such as added or deleted rows and columns, as not shown in cell edit history.
Is there a related page on sensitive data in sheets?
Yes, the help page on Google Sheets permissions and sensitive data.
Sources
How was this page made?
I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.