Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NOW() and SECOND() not refreshing
I assumed that NOW() in a cell (say A1) would produce a constantly changing field, so if formatted as hh:mm:ss it would show the time changing. Similarly if I enter SECOND(A1) in another cell it should show the seconds constantly counting up from 0 to 59, over and over. What happens is that values appear in the fields but they don't change unless I refresh the screen manually in one way or another. I have Calculation set to Automatic. A friend does the same thing and his times are constantly changing but we can't see what the difference is between our settings. Any suggestions please ? I'm trying to develop something which needs the time to be changing and can't even get to first base ! Thanks in advance tgmjf -- tgmjf ------------------------------------------------------------------------ tgmjf's Profile: http://www.excelforum.com/member.php...o&userid=36507 View this thread: http://www.excelforum.com/showthread...hreadid=562634 |