Permission & Access Issues

Restrict Access to Confidential Worksheets in a Shared Excel Workbook

Natalie TaylorNatalie Taylor Nov 18, 2026 870 views

Question details

The user needs to limit which employees can view confidential information in a shared Excel workbook.

Restrict Access to Confidential Worksheets in a Shared Excel Workbook
Product
Microsoft Excel, SharePoint, and OneDrive
Device & OS
not provided
Scenario
A shared workbook contains worksheets intended for different groups of employees.
Observed behavior
Standard worksheet protection can restrict editing but does not provide reliable user-based confidentiality within the workbook.
Before you start

Identify which employees need each set of data and check whether formulas, queries, or other sheets depend on the confidential information. You will need permission to manage sharing in the relevant SharePoint site or OneDrive location.

Solution 1Recommended

Separate Confidential Sheets into Restricted Workbooks

Use separate files and SharePoint or OneDrive permissions when different employees need access to different data.

SharePoint and OneDrive permissions apply to files and locations, not to individual Excel worksheets. Hiding or protecting a sheet should not be treated as a confidentiality control.

1
Create separate workbooks

In Excel, right-click each relevant sheet tab and use Move or Copy to place sheets in new workbooks for their intended audiences. Check formulas, links, and queries after moving or copying the sheets.

2
Prepare a clean general workbook

Create a separate workbook for all employees that contains only information they may see. Inspect hidden sheets, formulas, queries, and other content for confidential data before sharing it.

3
Store and restrict the files

Upload each workbook to an appropriately restricted SharePoint or OneDrive location. Select the file, open Manage access, and review inherited access and existing links; remove or change access where permitted, then grant access to the intended people or groups.

4
Share with specific people

Select Share for each workbook and choose Specific people in the link settings when available. Enter the authorized recipients and send the link.

5
Verify access

Review Manage access for each file and test with accounts from the intended and excluded groups. Confirm that site owners or administrators with broader permissions are appropriate recipients.

Separate Confidential Sheets into Restricted Workbooks
Review earlier access: Separating files cannot revoke information already downloaded or copied. Previous versions of an existing shared file may also contain confidential data, so review its access and version history.
Free Microsoft Office alternative

Work with Separate Excel Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Its compatibility with Excel formats makes it easy to move existing workbooks into WPS and organize data into separate files. Use your storage service's permissions to control who can open each file.

Organize worksheets into separate workbooks for different audiencesOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight Office alternative
QA img-9

Frequently Asked Questions

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

Excel worksheet protection does not provide reliable user-based confidentiality within a shared workbook. Put confidential sheets in separate files and control access to each file through SharePoint or OneDrive.

Does hiding or protecting a worksheet keep its data confidential?

No. Hiding a sheet or using Review > Protect Sheet can help control visibility or editing, but neither should be relied on to keep data confidential from people who can access the workbook.

Where can I check who can access a workbook?

In SharePoint or OneDrive, select the workbook and open Manage access to review people, groups, and sharing links. Also check inherited access from the containing location.

What happens to formulas when I move a worksheet to another workbook?

Formulas may change to reference the original workbook or stop working if their source data is unavailable. After using Move or Copy on a sheet tab, check formulas, external links, and queries in the new file.

Will removing a confidential sheet from a shared workbook erase earlier copies?

No. Earlier downloaded copies may still exist, and previous file versions may retain the sheet. Review access to the original file and its version history, and share a clean separate workbook with the broader audience.