Restrict Excel Worksheet Access for Different Users
Question details
The user wants each office user to view only their own worksheet while an administrator can access all worksheets.

- 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.
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.
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.
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.
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.
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.
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.

Evaluate Microsoft 365 rights management or a reporting solution
Use this approach when the organization needs centrally managed restrictions or many users need access to different subsets of data.
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.

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.




