View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
hoyt hoyt is offline
external usenet poster
 
Posts: 7
Default date last updated

Hello

Is there a way to show on the excel worksheet when it was last updated.
i.e. not when it was just last saved but when the data was actually modified
whether it be via a link or manually inputted. i know the time will change
every time any cell is selected but i need it to remember when a cell is
altered, ive tried using a circular reference but this only shows the time
that the data was origionally inputted i.e.
=IF(CF3="","",IF(CH3="",TODAY(),CH3))

any ideas

Regards

Hoyt