Tracking Changes

[Michael]

Hi Folks - I'm trying to get a handle on tracking changes. I turn it on. I
make changes. Excel 2003 displays the changes in comment boxes. All is well.
I save and close the file. I open the file. The changes are not visible. Can
you help?

Michael

 

[Michael]

Here's a follow-up ....

If I create a new workbook, turn on track changes and select "All" next to
When, make changes to the sheet, I see the changes highlighted. But, if I
then save the workbook, close it and open it again, the changes aren't
highlighted, and any changes I make from then on, aren't highlighted. If I
open the Highlight Changes dialog box, the When field has automatically
changed from "All" to "Since I last saved." Everything else has remained the
same. If I select "All" in the When field, then I see the changed cells
highlighted.

I'd rather avoid having to open the Highlight Changes dialog box again to
make that "All" selection. Is there any way to lock it on that setting?



Thanks.

 

[Pete_UK]

Michael,

In Tools | Share Workbook you have to set the Keep Change History radio
button - you can specify the number of days you want to keep this for.

Hope this helps.

Pete

 

[Michael]

Pete - It is set to 30 days. What should it be set to?

Michael