You will need a recalculation to update the time.

F9 works fine for me.


Gord Dibben MS Excel MVP

On Mon, 25 Dec 2006 10:49:00 -0800, jschlis
wrote:

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