This depends on the version of Excel you are using. If you attempt to use Unshare Workbook, Track Changes will also be disabled. The disadvantage of shared workbooks and henceforth of Tracked Changes is that many other features would be grayed out and unavailable. This is because Tracked Changes is only applicable to shared workbooks with multiple simultaneous users. When Track Changes are enabled, note that the previously grayed-out Unshare Workbook button is now also enabled. Track Changes only applies to shared workbooks.Automatic changes in cell values as a result of formulas will not be marked. Changes made by other users are denoted by different color borders. All changes are denoted by the same blue border and the change in color of the column header.The color of the column header of the changed cell goes from black to purple: The infotip displays the author, date and time of the change, the location of the changed cell, and the value of the cell before and after the change. Hover the cursor over this cell to see the infotip related to the change made to the cell: If you have turned on Track Changes with the settings mentioned above, this is how a change made to a cell value will appear:Īfter changing the date from the 7 th to 8 th, the change is marked by surrounding the cell with a dark blue border with a small blue arrow on the top-left corner: Once Track Changes has been enabled, any changes made to the cells are tracked. Learn how Track Changes works and what it does right ahead. The changes can be accepted or rejected, switching the rejected changes back to the original values. These changes can be viewed as highlighted on the worksheet and also enlisted in a separate sheet. Track Changes in Excel allows users to review changes made to the worksheet. Step 1 – Adding Track Changes to the Review tab by customizing the ribbon:.How Does The Track Changes Feature Work?.

How to add comments vba in excel 2016