NOW() and SECOND() not refreshing

[tgmjf]

I assumed that NOW() in a cell (say A1) would produce a constantl
changing field, so if formatted as hh:mm:ss it would show the tim
changing.
Similarly if I enter SECOND(A1) in another cell it should show th
seconds constantly counting up from 0 to 59, over and over.

What happens is that values appear in the fields but they don't chang
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 bu
we can't see what the difference is between our settings.

Any suggestions please ? I'm trying to develop something which need
the time to be changing and can't even get to first base !
Thanks in advance
tgmj

 

[Biff]

Hi!

Just a partial answer.......

Those functions are working properly. They will only update when a
calculation is triggered.

If you want a real time clock that will require some VBA code.

Biff

 

[tgmjf]

Thanks Biff !
I guess my friend must have something else calculating - maybe a loo
or a counter or something.
Anyway at least I know they shouldn't work unless another cal
happens.
Thanks again
tgmj