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