Permission & Access Issues

Restrict Excel Worksheet Access for Different Users

Rana GarciaRana Garcia Nov 18, 2026 871 views

Question details

The user wants each office user to view only their own worksheet while an administrator can access all worksheets.

Restrict Excel Worksheet Access for Different Users
Product
Microsoft Excel
Device & OS
not provided
Scenario
Sharing worksheet data with different users while keeping other users' data private.
Observed behavior
The desired arrangement gives each user access only to their own data and the administrator access to all data.
Before you start

Identify which data belongs to each user and where the files will be stored. Check whether your organization uses OneDrive or SharePoint and whether you can control sharing permissions for individual files.

Solution 1Recommended

Share a separate Excel workbook with each user

Use individual files and file-level permissions when users must not see one another's data.

Excel sheet hiding and worksheet protection are not reliable controls for keeping confidential data from people who can open the workbook. Separate files let you apply permissions to each user's data.

1
Create individual workbooks

In Excel, create a workbook for each user and copy only that user's data into it. Check that hidden sheets, formulas, and external links do not expose other users' information.

2
Store files with restricted access

Upload the files to OneDrive or SharePoint in a location that is not already shared with all users. Review inherited folder permissions before sharing individual files.

3
Share each file

Select a file, choose Share, and use the Specific people option if available. Enter only the intended user's account and choose whether they can edit or only view the file.

4
Verify administrator access

Keep the files under an account managed by the administrator, or grant the administrator access to each file. Use Manage access to check permissions and test with a user account.

Share a separate Excel workbook with each user
Check organization settings: Sharing options and permission inheritance depend on your Microsoft 365 configuration. Contact your administrator if you cannot restrict access as needed.
Free Microsoft Office alternative

Work with Individual Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. It can open and edit individual Excel files, making it easier to move existing workbooks into a separate-file workflow. File access must still be controlled through your storage service.

Open and edit Microsoft Excel XLSX filesWork with separate spreadsheets for different usersUse a familiar spreadsheet interface when moving from ExcelGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I give different users access to different sheets in one Excel workbook?

Excel does not provide reliable user-specific confidentiality for individual sheets in a shared workbook. For sensitive data, place each user's data in a separate file and set file-level sharing permissions.

Does hiding or protecting a worksheet keep its data private?

No. The Hide command and worksheet protection are useful for organization or limiting edits, but they are not strong confidentiality controls for someone who can open the workbook.

Can VBA show a sheet based on a user's Windows username?

A Workbook_Open macro can use a Windows or network username to show or hide sheets, but this is not secure by itself. Macros may be disabled, and behavior depends on the Excel version and storage environment.

How can I check who can open a shared workbook?

In OneDrive or SharePoint, select the file and choose Manage access. Review direct access, sharing links, and inherited permissions, then remove access that is not needed.