You can use an OnTime event macro to perform periodic re-calculations. See:

http://www.cpearson.com/excel/OnTime.aspx
--
Gary''s Student - gsnu2007L


"wilchong via OfficeKB.com" wrote:

Dear sir,
I set an excel formula =NOW() which show the time. However, the time will
only refresh when I hit the formula.

My question is that is there possible to set a excel formula which we can see
the second (ss) moving?

Many thanks,
Wilchong

--
Message posted via http://www.officekb.com