Collaboration
Share useful sheets without losing control
Prepare a workbook for collaboration, decide what others should change, and protect the parts that must stay reliable.
Before you share
Make the sheet understandable on its own
- Use clear sheet and column names.
- Keep raw data, calculations, and final views easy to distinguish.
- Add notes for assumptions, update dates, and important exceptions.
- Remove temporary examples or private values that do not belong in the shared version.
Access
Give people the access they need
Share from the workspace controls when the file is ready. Choose the narrowest access that supports the job, especially when a person only needs to read a report or update one area.
Keep an owner or editor responsible for formulas, structure, and final review. Collaboration works better when everyone knows which parts are open for input and which parts are maintained centrally.
Protected ranges
Protect important cells and formulas
Use protected ranges for assumptions, calculated columns, lookup tables, and other cells that should not be changed casually. Pair protection with a short note that explains where people should enter their updates.
Protection is a guardrail, not a substitute for a review process. Keep a clean source version and check the workbook after a major collaboration cycle.
Permission levels
Choose view, comment, or edit with care
View
Best for reports and finished work that someone needs to read without changing.
Comment
Useful when someone should review the sheet and leave feedback without editing values.
Edit
Use when the person is responsible for updating the workbook or completing assigned work.
Review existing shares when the project changes. You can adjust access, set an expiry when appropriate, or remove access that is no longer needed.
A simple sharing process
Share in three steps
- Prepare the workbook and remove anything that does not belong in the shared version.
- Choose the person, permission, and expiry that fit the task.
- Review the share list after the person has finished or the project changes.
If someone needs to work on only part of a workbook, combine a narrow permission with a protected range or a separate input sheet. If they need a finished report, view access is usually enough.
When access changes
Review shares at the end of the project
Temporary access should have a clear reason and an end point. When a review, handoff, or contract ends, remove the share or let its expiry do the work. Check both direct shares and team assignments.
If a person needs a different kind of access later, update the existing permission instead of creating several overlapping shares. Fewer entries make the access list easier to audit.