Tracking the date a cell was last changed

[papercontracts]

Hi. Can anyone tell me if there's a way to see the date when an individual cell was last changed in a spreadsheet? Thanks, David.

 

[ADAMC]

Edit**

Hi Papercontracts!

Tools> Track changes> highlight changes>
Choose When> All
Who> Everyone
Where> Choose your cell eg A1.

You can choose to track changes by a comment in cell or changes can be stored on a sheet whcih you could just hide or password protect.

Hope this helps
PS Welcome to the board!!

 

[papercontracts]

Hi. Thanks for the welcome, and for the answer. However I want a 'last changed' date that persists when the document is saved and re-opened. With Track Changes, that info is lost when the document is saved, I think. David