Excel Sharing Permissions Across Multiple Sheets

It was a Thursday afternoon when I got the Slack message: "Jace, the sales tracker is broken. Everyone can edit the Raw Data tab." Four territory managers and a finance lead had been sharing the same regional workbook for three weeks, and someone had forwarded the OneDrive link internally as an edit link. The sheet protection I'd set? Gone. Not broken. Gone, as if it had never existed.

That's the thing most guides skip entirely: Excel sharing permissions across multiple sheets aren't one system. They're two systems running in parallel, and if you don't set them up in the right order, they'll quietly undo each other. Here's how to do it correctly, and what to check when it stops working.

What You'll Need Before You Touch Excel Sharing Permissions Across Multiple Sheets

The goal here is giving different people different levels of access to different sheets inside a single workbook: read-only on one tab, edit rights on another, locked out of a third entirely. Before you touch any settings, you need a Microsoft 365 account, the workbook already saved to OneDrive or a SharePoint document library, and a clear answer to the question my old mentor Diane drilled into me: who needs to see what, and who needs to edit what? That question comes before any password.

The Two-Layer Problem: Workbook-Level Sharing vs. Per-Sheet Protection

Workbook-level permissions control whether someone can open the file at all, set via the OneDrive or SharePoint sharing link. Per-sheet access control lives inside the file: passwords on individual tabs, unlocked cell ranges for specific users. These are separate systems. The sharing link has no idea your Raw Data tab is protected. And your sheet protection has no idea what kind of link you sent. That gap is where things break.

If you're new to how Excel handles file access at a broader level, the Excel file management and sharing overview covers the foundational concepts worth knowing before you start layering permissions.

---

Step 1: Lock Down Individual Sheets First, Before You Share the Workbook With Anyone

This is the sequence almost everyone gets backwards. Once you've got a clear picture of your permission map, you apply in-file protection before the sharing link ever gets created. Doing it after is asking for the exact Thursday afternoon I described above.

Protect Each Sheet With a Password Using the Review Tab

1. Select the sheet tab you want to protect.
2. Go to Review → Protect Sheet.
3. Set a sheet protection password, then confirm it. Write it down somewhere you'll actually find in six months.
4. Choose which actions unprotected users can still perform: selecting locked cells, sorting, using AutoFilter. Be deliberate here. The defaults are more restrictive than most people expect.
5. Repeat for each tab that needs its own protection level.

Protection behavior differs between Microsoft 365 and Excel 2019. In 2025, most organizations have moved to 365, but if anyone on your team is on an older standalone version, test the protected file on their machine before you share it widely. The experience is not always identical.

Use Allow Edit Ranges to Give Specific Users Exceptions

The Allow Edit Ranges dialog, also under the Review tab, is where you carve out editable zones for specific users while keeping the rest of the sheet locked. It gives you the granular control you actually need, assuming all users are on the same network domain, which isn't always the case.

Watch out for merged cells. They interact unpredictably with sheet protection: adjacent unlocked cells can become unselectable for users when merging is involved. Unmerge before you protect. Always.

One more thing worth internalizing: protect sheets at the structural level, not the visual level. Don't lock cells because they're color-coded gray. Lock them because they're downstream calculations that users shouldn't overwrite. Map the data flow first, then apply protection to match it.

---

Step 2: Share the Workbook via OneDrive or SharePoint Without Breaking the Sheet Protection You Just Set

Once the in-file protection layer is solid, you're ready to handle the sharing link. This is where the two systems either work together or fight each other.

Why Co-Authoring Conflicts With Sheet Protection (and the Workaround)

Excel co-authoring with sheet protection enabled is a genuinely unstable combination. Microsoft 365's co-authoring engine was built for simultaneous editing, and it doesn't always honor per-sheet passwords the way you'd expect when multiple users are active in the file at once. Real users report that applying Allow Edit Ranges and then sharing via an OneDrive edit link breaks the expected protection behavior: ranges that should be locked become editable.

The fix is less elegant than I'd like, but it holds. Share the file as Can View at the OneDrive or SharePoint link level. Let the in-file passwords control who can edit which tab. Users who need edit access get the sheet password directly, not an edit link. This keeps the two layers from contradicting each other.

Share as "Can View" at the link level. Let in-file passwords decide who edits what. Never rely on an edit link to respect your sheet protection.

For enterprise environments using a SharePoint document library, there's another wrinkle: SharePoint permissions layer on top of the file's internal protection. A user with "Edit" rights in SharePoint can overwrite an unprotected sheet regardless of what the sharing link says. The SharePoint permission is the outer gate; in-file protection is the inner gate. Both have to be configured intentionally. Microsoft's co-authoring documentation covers the known limitations, though it doesn't offer much guidance on the hybrid approach.

---

Common Mistakes When Managing Excel Sharing Permissions Across Multiple Sheets

Including the one that wipes your protection silently.

First: sharing before protecting. If you send the OneDrive link before setting sheet protection, some Microsoft 365 sync behavior can reset the protection state when the file is first opened by another user. Set protection first. Share second. No exceptions.

Second: assuming an edit-level OneDrive link respects per-sheet passwords. It doesn't always. I've tested this across three client environments and the behavior is inconsistent enough that I stopped trusting it entirely. Use the Can View link plus direct password sharing as the reliable alternative.

Third: doing all of this manually across a 14-tab workbook. A short VBA macro to protect multiple sheets at once is not optional at that scale. It's the only approach that doesn't introduce human error. A basic loop through the Sheets() collection, calling .Protect or .Unprotect with your password on each tab, takes about eight lines of code and saves you from the manual step you'll inevitably miss on tab eleven. If you want to go deeper on the VBA route, Microsoft's Worksheet.Protect VBA reference has the full parameter list.

The best analysts I've worked with build solutions simple enough that their replacement can understand them in fifteen minutes. That applies here: label each protected tab clearly, document the password policy somewhere in the workbook itself (a hidden admin sheet works), and write a one-line comment explaining why each range is locked the way it is. The inherited workbook nightmare, the one where you open a file and spend an hour figuring out why half the cells are inaccessible, is almost always a documentation failure, not a technical one.

If you're working through your overall approach to protecting Excel files, the guide on protecting workbook structure in Excel covers the structural side of this, and the Excel starter guide is worth bookmarking for anyone on your team who's newer to these concepts.

---

Frequently Asked Questions