You build a clean spreadsheet, send the link to a client or teammate, and instead of the data they get a grey wall: you need access, request access, you don’t have permission. Now you are trading emails, they are annoyed, and your tidy deliverable looks broken. The good news is that this error almost never means the file is damaged. It means a sharing or account setting is in the way, and there are only a handful of usual suspects.
A “you don’t have permission” error in Google Sheets comes down to who is asking, how the file is shared, and whether an organization policy is blocking it. Work through the causes in order and you will find the culprit quickly, whether it is the person opening the file or a setting on your side. Here is the sequence that fixes it.
At a Glance
The most common cause is the wrong Google account being signed in, since many people are logged into several at once. Next is the sharing setting itself: the file may be Restricted to specific people, or the person needs Editor rather than Viewer access. Third is an organization policy, where a Google Workspace admin blocks sharing with outside or personal accounts. Templates add a copy trap, and protected ranges can let someone open a sheet but not edit part of it. Check the signed-in account first, then the share settings, then whether a Workspace domain restriction is involved.
Check Which Account You’re Signed Into First
This is the single most common cause, so start here before touching any sharing setting. If you or the recipient are signed into more than one Google account in the same browser, the file often opens under the wrong one, which has no access, and Google shows the permission error even though the correct account was invited.
Have the person check the account avatar in the top right and confirm it matches the email the file was shared with. Switching to the right account frequently clears the error on its own. If that is awkward, opening the link in an incognito window and signing in with only the correct account is a clean way to rule account confusion out entirely.
Fix the Sharing Setting Itself
If the account is right and access is still denied, the file’s sharing configuration is the next place to look. In Google Sheets, the Share panel controls who can open the file and what they can do. Two settings cause most trouble.
First, general access may be set to Restricted, meaning only specifically invited people can open it. Either add the person’s exact email, or set general access to “Anyone with the link” if the content is not sensitive. Second, check the access level: someone with Viewer access cannot edit, so if they need to change data, set them to Editor. As Google Drive’s sharing help lays out, Viewer, Commenter, and Editor each allow different actions, and the wrong level looks like a permission failure when someone tries to do more than their role allows.
When Your Workspace or the Owner’s Org Blocks It
Sometimes the settings look correct and it still fails, and that points to an organization policy. Many companies and schools run Google Workspace with rules that limit sharing outside the organization, and those rules override what you set on the file.
If your account is managed, a Workspace administrator may block sharing with personal Gmail accounts or with domains not on an approved list. As Google’s admin documentation explains, organizations can restrict external sharing to only trusted domains, which is why a client on a personal address cannot open a file that a coworker opens fine. The fix is to share with an address inside an allowed domain, or to ask the administrator to permit the specific external domain.
The Template “Make a Copy” Trap
If you hand out a spreadsheet as a reusable template, a different version of this error appears. People who should copy the file instead get blocked, usually for one of two reasons.
Either the sharing link points to the original file with only Viewer access, so they cannot edit it and do not realize they were meant to copy it, or the owner has turned off the option that lets viewers download and copy. For a template, share it with Viewer access, turn on the copy option, and give people a link that ends in /copy so it prompts them to make their own editable version. That keeps your master intact while everyone gets a working copy.
When They Can Open It but Not Edit Part of It
A narrower version of the problem is when someone opens the sheet fine but gets a permission message only when editing certain cells. That is a protected range, not a sharing failure.
Sheets lets an owner protect specific ranges or entire tabs so only chosen people can change them, which is useful for a client template where you want inputs editable but formulas locked. If a collaborator reports they cannot edit one area, open Data, then Protected sheets and ranges, and either add them to the allowed editors or adjust the protection. The rest of the file stays open while the protected part is the only thing restricted.
Quick Diagnostic Guide
| What you see | Likely cause | Fix |
|---|---|---|
| “You need access” on opening | Wrong account or not invited | Switch account, or add their email |
| Opens but cannot edit | Viewer access, not Editor | Change their role to Editor |
| External client blocked, coworker fine | Workspace domain restriction | Share to allowed domain, or ask admin |
| Cannot copy a template | Copy disabled or wrong link | Enable copy, share a /copy link |
| Blocked on certain cells only | Protected range | Add them as an allowed editor |
Key Takeaways
- Check the signed-in Google account first, since the wrong one among several is the most common cause.
- Set the file to the right general access, and give Editor rather than Viewer access to anyone who needs to change data.
- A Google Workspace domain restriction can block outside or personal accounts regardless of your file settings.
- For templates, enable copying and share a link ending in /copy so people get their own editable version.
- Being blocked on specific cells is a protected range, fixed by adding the person as an allowed editor.
Frequently Asked Questions
Why does Google Sheets say I need permission when I was given access?
Almost always because the wrong Google account is active in your browser. If you are signed into several accounts, the file can open under one that was never invited. Check the account avatar in the top right, confirm it matches the invited email, and switch accounts or use an incognito window with only the correct account signed in.
How do I let someone edit instead of just view my sheet?
Open the Share panel, find the person’s name, and change their role from Viewer to Editor. Viewer access allows opening only, so anyone who needs to change data will hit a permission block until you raise them to Editor. If you shared by link, make sure the link’s role is set to Editor as well.
Why can my coworker open the sheet but my client cannot?
This usually points to a Google Workspace domain restriction. Many organizations block sharing with personal accounts or with domains not on an approved list, so an internal coworker opens the file while an external client on a personal address is denied. Share with an address on an allowed domain, or ask your administrator to permit the client’s domain.
How do I share a spreadsheet as a template people can copy?
Share the file with Viewer access, keep the option that lets viewers copy turned on, and give people a link that ends in /copy instead of /edit. That prompts each person to create their own editable copy, leaving your master file untouched. It avoids the common problem of collaborators editing, or being blocked from, the original.
What To Do Next
Run the checks in order: confirm the right account is signed in, then the file’s general access and each person’s role, then whether a Workspace policy is blocking outside accounts. For templates, switch to a /copy link with copying enabled, and for locked cells, adjust the protected range. Nine times out of ten it is the account or the share setting, and a two-minute pass clears it before the back-and-forth emails start. For more workflow fixes, see our Business and Tech News sections.