Can You Track Changes in Excel?
When you want your team to review and edit your Excel workbook, you have two options. If everyone on your team uses Excel for Microsoft 365, the co-authoring feature is a straightforward and quick way to review a document. If you want more information about the revisions made or if your team members work with older versions of Excel, use the legacy Track Changes feature. You won’t find the option to track changes in Excel for Microsoft 365 and Excel 2019 on the Excel Ribbon. You’ll only see the track changes commands in the Review tab of Excel 2016 and older versions. The option is available in newer versions of Excel, but you’ll need to add the associated track changes commands to a new group in the Review tab.
Enable Track Changes in Newer Versions of Excel
To enable the legacy Track Changes feature in Windows:
How to Turn On Track Changes in Excel
After you’ve entered all the information in the worksheet, turn on the Track Changes feature before making the Excel workbook available for review.
Compare and Merge Workbooks (Legacy)Protect Sharing (Legacy)Share Workbook (Legacy)Track Changes (Legacy)
After you select each command, select Add to add that command to the Review tab.
Share the Workbook
When your shared workbook is ready to be reviewed, upload the file to a location that your team members can access. For example, upload the workbook to a SharePoint site, a OneDrive folder, or Dropbox. After the workbook is uploaded, inform your team members that the file is ready for their review. One way to do this is to use the Share feature in Excel.
How to View and Accept Changes
After all your reviewers have had a chance to review and edit the workbook, it’s time to accept or reject those changes.
How to Turn Off Track Changes
When you’re finished with the review and don’t want to continue to track changes made to the workbook, turn off the Track Changes feature.
