update time

[jschlis]

I put in the time function" =now()". How can this automatically update like a
clock does, with recalculating or hitting f9

 

[Gord Dibben]

You will need a recalculation to update the time.

F9 works fine for me.


Gord Dibben MS Excel MVP