Office Settings & Configuration

How to Prevent Users from Disabling Track Changes in Excel

Tauseeq MagsiTauseeq Magsi Nov 11, 2026 868 views

Question details

The user wants to know if there is a way to strictly prevent other collaborators from turning off the Track Changes feature in an Excel workbook.

How to Prevent Users from Disabling Track Changes in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Sharing a workbook for review and ensuring all edits remain tracked without the risk of users disabling the feature.
Observed behavior
Excel allows users with sufficient edit access to turn off Track Changes, which can lead to untracked modifications during collaboration.
Before you start

Before applying protection measures, ensure you have clearly communicated the review process and expectations with your team to minimize unauthorized modifications.

Solution 1Recommended

Password-Protect and Encrypt the Workbook

While you cannot lock the 'Track Changes' button itself, restricting overall access using a password prevents unauthorized users from modifying the file.

Excel does not provide a built-in feature to specifically lock the Track Changes function. The most effective workaround is to enforce strict workbook access controls.

1
Navigate to the File menu

Open your workbook and click on the 'File' tab located in the top-left corner of the Excel ribbon.

2
Access the Protect Workbook options

Click on 'Info' from the left-hand navigation pane, then click the 'Protect Workbook' dropdown button.

3
Encrypt with Password

Select 'Encrypt with Password' from the dropdown menu. Enter a strong password, click 'OK', and then re-enter the password to confirm.

4
Save the workbook

Save your document. Only trusted users who are given the password will be able to open and edit the workbook, reducing the risk of unauthorized users disabling tracking.

Password-Protect and Encrypt the Workbook
Important Password Notice: Keep your password in a safe place. If you forget or lose the password, Microsoft Excel cannot recover the data in the workbook.
Free Microsoft Office alternative

Collaborate Securely with WPS Spreadsheet

While no spreadsheet software completely locks the track changes button for users with full edit permissions, WPS Office provides robust workbook protection and a highly compatible environment for reviewing edits. Switch to WPS Office for a lightweight, free alternative that seamlessly handles your Excel files.

  1. 1. Download WPS Office: Visit the official WPS Office website to download and install the free suite on your device.
  2. 2. Open your Excel File: Launch WPS Spreadsheet and easily open your existing .xlsx documents without format loss.
  3. 3. Secure your Worksheet: Navigate to the Review tab and use the Protect Sheet or Protect Workbook features to tightly control editing permissions.
Fully compatible with Microsoft Excel (.xlsx) file formats.Robust workbook and worksheet protection features to secure your data.Built-in Track Changes and collaboration tools for efficient team reviews.Lightweight software with a familiar, easy-to-use interface.
microsoft office alternative - wps office

Frequently Asked Questions

Can I completely lock the Track Changes feature in Excel 365?

No, Excel 365 does not have a built-in feature to completely lock or prevent users with edit access from turning off Track Changes. You must rely on workbook encryption, sheet protection, and team communication to manage editing behavior.

How do I know if someone turned off Track Changes in my workbook?

If the feature is disabled by a user, their subsequent edits will no longer highlight or appear in the revision log. It is highly recommended to review tracked changes regularly so you can spot unauthorized modifications or missing tracking data early.

Does sharing the workbook as read-only enforce Track Changes?

If a workbook is set to read-only, users cannot make changes at all. To allow tracked edits, they need edit permissions, which unfortunately also grants them the ability to toggle the Track Changes setting from the Review tab.