Permission & Access Issues

Can You Turn Off Show Changes in a Shared Excel Workbook?

Nimra MalikNimra Malik Nov 18, 2026 871 views

Question details

The user wants to prevent selected employees' edits from being visible through Show Changes while collaborators edit a shared workbook.

Can You Turn Off Show Changes in a Shared Excel Workbook?
Product
Microsoft Excel
Device & OS
not provided
Scenario
Employees collaborate on an Excel workbook that may contain sensitive HR information.
Observed behavior
Show Changes displays workbook edits to collaborators and does not provide reliable user-specific privacy controls.
Before you start

In Excel, open Review > Show Changes to understand what the shared workbook displays. Identify any confidential employee data in the workbook and check who has access to its SharePoint or Teams location.

Solution 1Recommended

Separate confidential data and restrict workbook access

Use separate files and SharePoint permissions when employees should see only their own information.

Excel does not offer a reliable way to hide selected users' changes while everyone edits the same file. Clearing or filtering displayed changes is not a security control.

Hidden sheets, formulas, and worksheet protection do not prevent someone with file access from viewing confidential data.

1
Create separate files

In Excel, create a separate workbook for each employee or group that needs access. Include only the data that each intended recipient is authorized to see.

2
Store files securely

Save the workbooks in SharePoint or the appropriate Teams file location, using separate folders or files where different access is needed.

3
Review permissions

In SharePoint, select a file or folder and open Manage access. Remove unnecessary access and review inherited permissions and existing sharing links.

4
Share with intended recipients

Use Share and choose specific people where available. Verify that each employee can access only the files intended for them.

5
Restrict the original workbook

Use Manage access on the original shared workbook to remove inappropriate access. Review whether prior copies or sharing links also need attention.

Separate confidential data and restrict workbook access
Access changes are not retroactive: Restricting a file does not recover copies or information that someone has already downloaded or viewed.
Free Microsoft Office alternative

Work with Excel files in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. It does not change Excel's Show Changes privacy controls; restrict access to confidential files separately.

Create separate workbooks for different audiencesOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I hide one employee's edits in Excel Show Changes?

Excel does not provide a reliable user-specific privacy setting for hiding selected employees' edits while everyone shares the same workbook. Use separate files with restricted access instead.

Does clearing or filtering Show Changes protect confidential data?

No. Clearing or filtering what appears in the Show Changes pane is not a secure way to control access to sensitive information.

Are hidden or protected worksheets secure enough for HR data?

No. Hidden sheets and worksheet protection are not reliable confidentiality controls for people who can access the file. Store sensitive data in a restricted HR system or separate files with appropriate permissions.

Where can I check who can access a shared workbook?

In SharePoint, select the workbook and open Manage access to review people, groups, and sharing links. Also check inherited permissions on its folder or site.