Permission & Access Issues

Can Excel Restrict Access to Individual Worksheets by User?

Adam DavisAdam Davis Nov 18, 2026 869 views

Question details

The user wants different people to access only their permitted worksheets in a shared Excel workbook.

Can Excel Restrict Access to Individual Worksheets by User?
Product
Microsoft Excel
Device & OS
not provided
Scenario
A shared workbook contains departmental sheets that should be visible only to authorized users.
Observed behavior
Worksheet protection can restrict editing, but Excel does not provide reliable user-specific viewing permissions for individual sheets.
Before you start

Identify which users should be able to view each department's data and check where the workbook is stored. Review existing access to the original workbook before distributing separate files.

Solution 1Recommended

Use Separate Workbooks With File-Level Permissions

Use separate files when departmental data must remain confidential from other users.

1
Create department files

In Excel, create a separate workbook for each department and copy only the sheets and data its users are allowed to access.

2
Check each file's contents

Open each new workbook and check its sheets, hidden sheets, and formulas for data that the intended recipients should not see.

3
Share with specific people

Upload the files to OneDrive or SharePoint. For each file, select Share, choose Specific people in the link settings, and enter the authorized users.

4
Review existing access

Use Manage access on each file to review existing users, groups, and links. Remove unwanted access where permitted, and review access to the original shared workbook as well.

5
Verify permissions

Ask an authorized user to open their file and confirm that an unauthorized account cannot open it. Review the file's sharing settings if access is broader than intended.

Use Separate Workbooks With File-Level Permissions
Sharing links are not the whole permission set: A Specific people link does not remove access already granted through other links, groups, or inherited site permissions.
Free Microsoft Office alternative

Work With Separate Department Workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for working with separate department files. It supports Excel formats for an easier transition, but access to sensitive files must still be controlled through your storage or sharing service.

Work with separate spreadsheets for different departmentsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceKeep file access controls with your storage or sharing provider
microsoft office alternative - wps office

Frequently Asked Questions

Can I give each user access to just one tab in an Excel workbook?

Excel does not provide reliable user-specific viewing permissions for individual tabs. Put confidential sheets in separate workbooks and control access to each file through OneDrive, SharePoint, or another secured service.

Does Protect Sheet stop users from viewing a worksheet?

No. Review > Protect Sheet restricts editing and other selected actions, but it does not make the sheet confidential to someone who can open the workbook.

Is hiding a worksheet enough to protect sensitive data?

No. Hidden sheets and workbook structure protection are not reliable security boundaries. Remove sensitive data from files shared with unauthorized users instead.

Does a Specific people link remove everyone else's access?

No. In OneDrive or SharePoint, select Manage access to review other links, direct permissions, and applicable group or inherited access. A new sharing link does not automatically revoke existing permissions.