7

I have an excel workbook (.xlsx) in which I want to track changes. However track changes button is grayed out. I tried searching, but couldn't find any solution.

This workbook contains 5 worksheets, so I tried moving (copying) each sheet to a new workbook, and I found that when I copy one particular sheet, track changes option gets grayed out in the new workbook. So there is something in this sheet which is causing track changes to be grayed out.

Attached is the screenshot Larger Image

3
  • Is the spreadsheet password protected?
    – Burgi
    Commented Feb 18, 2016 at 9:23
  • No, its not password protected. Commented Feb 18, 2016 at 10:38
  • Can you add a screenshot to your question?
    – Burgi
    Commented Feb 18, 2016 at 11:08

1 Answer 1

7

Finally I found answer to the solution. Apparently the track changes option is disabled (grayed out) if any of the sheet contains a table. There was one table in one of the sheets of the workbook. When I changed the table back to range, I was able to track changes.

2
  • 1
    The same issue and solution exists in Excel 2016.
    – kwill
    Commented Feb 5, 2018 at 14:54
  • To convert table to range >> right click on table and choose from context menu Table > Convert to range. More
    – zar
    Commented Jul 16, 2018 at 19:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .