I am trying to use the track changes option. I have a multi sheet workbook and want to track changes in different cells on each sheet. However I cannot figure out how to enter these references into the Where: option of highlight changes. I can select one sheets cells, as soon as I enter a second pages cells it tells me that I have an invalid reference.
How can I track changes of certain cells accross multiple sheets of the same workbook?
How can I track changes of certain cells accross multiple sheets of the same workbook?