"Track Changes" Button in Excel is disabled

Question

"Track Changes" Button in Excel is disabled on MAC:

Originally, I didn't have the button on my Ribbon and Toolbar. I googled and was able to add it, but it's disabled (in-active) and not sure what to do!

Answer 1

Hi,

I'm Ajibola, an Independent Consultant here and a Microsoft user like you. I don't work for Microsoft and cannot access any of your data on their system.

The Track Changes button is no longer available in the ribbon in the newer versions of Excel for Mac. In order to use this feature, you will need to add Track Changes back to the ribbon first¹. If that doesn't work, you can try turning on the disabled track changes option by following these steps³:

• Open a worksheet
• Go to Tools > Track Changes > Highlight Changes
• Place a checkmark across “Track changes while editing” option
• Click on the down arrow present next to When, Who, and Where

If none of these options work, you can try converting your tables to ranges and remove XML maps.

Reference: (1) Track changes in a Shared Workbook - Microsoft Support. https://support.microsoft.com/en-us/office/track-changes-in-a-shared-workbook-22aea671-cac7-4fa3-845d-eeb23725bd15.

(2) How To Fix Excel Track Changes Grayed Out Issue? -<removed by Moderator>

Kind regards Ajibola

Answer 2

@ Ajibola

The link (1) you provided is broken. Please fix it.

Thanks.

Answer 3

Hi Wajdi

Is Track Changes Legacy the button you added to the Ribbon? It's working for me. Choose Highlight Changes to display the dialog that turns tracking on.