track changes referencing multiple sheets

[bkndbrown]

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?

 

[DonkeyOte]

I typed excel track changes multiple sheets in google and came up with this:

http://en.allexperts.com/q/Excel-1059/Tracking-Changes-Excel-2000.htm

Which version of XL are you running ?

 

[DonkeyOte]

also, by the wonders of youtube see this online demo:

http://www.youtube.com/watch?v=0enUpenx2pM