Track changes in shared excel workbook

[MO22]

I have a shared workbook, shared between 3 users. I and User#2 set it up and tested it with change tracking and everything was ok. Now when I open the file, go to Tools-> Track Changes -> and try to create a History sheet, it doesn't show any records, even though I know that several users worked on the sheet that day.

I am also not seeing the marker for a changed cell. Any suggestions? What am I doing wrong here?

 

[SkipVought]

Have you checked the boxes in Track Changes for...

1. Track changes while editing and
2. When is All
3. List changes on a new sheet.

Works for me Skip,
metzgsk@voughtaircraft.com

 

[MO22]

Thanks, I just found my mistake. Apparently there is a final step, Tools, Protection, Protect Shared Worksheet, which prevents other users from wiping out the change history.

Thanks anyway1