How to Prevent Users from Disabling Track Changes in Excel
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.

- 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 applying protection measures, ensure you have clearly communicated the review process and expectations with your team to minimize unauthorized modifications.
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.
Open your workbook and click on the 'File' tab located in the top-left corner of the Excel ribbon.
Click on 'Info' from the left-hand navigation pane, then click the 'Protect Workbook' dropdown button.
Select 'Encrypt with Password' from the dropdown menu. Enter a strong password, click 'OK', and then re-enter the password to confirm.
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.

Protect the Worksheet to Restrict Specific Edits
Lock down specific cells or entire sheets so users can only make changes where explicitly permitted, reducing reliance on the Track Changes feature.
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. Download WPS Office: Visit the official WPS Office website to download and install the free suite on your device.
- 2. Open your Excel File: Launch WPS Spreadsheet and easily open your existing .xlsx documents without format loss.
- 3. Secure your Worksheet: Navigate to the Review tab and use the Protect Sheet or Protect Workbook features to tightly control editing permissions.

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.




