Can Excel Restrict Access to Individual Worksheets by User?
Question details
The user wants different people to access only their permitted worksheets in a shared Excel workbook.

- 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.
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.
Use Separate Workbooks With File-Level Permissions
Use separate files when departmental data must remain confidential from other users.
In Excel, create a separate workbook for each department and copy only the sheets and data its users are allowed to access.
Open each new workbook and check its sheets, hidden sheets, and formulas for data that the intended recipients should not see.
Upload the files to OneDrive or SharePoint. For each file, select Share, choose Specific people in the link settings, and enter the authorized users.
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.
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.

Protect a Worksheet to Prevent Accidental Edits
Use worksheet protection when users may see the data but should not change protected cells.
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.

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.




