Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time and Date stamp - Pivot Chart | Excel Discussion (Misc queries) | |||
Date in middle of month | Excel Discussion (Misc queries) | |||
Date formulas | Excel Discussion (Misc queries) | |||
How do I print the last date a worksheet was updated in a footer? | Excel Discussion (Misc queries) | |||
How do I keep the date from being updated every day | Excel Discussion (Misc queries) |