I suppose you could use something like AutoHotKey
(http://www.autohotkey.com) to feed an F9 to Excel every second, but
that seems sort of wasteful. Can you tell us why you need a live clock
in an Excel spreadsheet? There are lots of clock gadgets you can run
that would seem more efficient.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"wilchong via OfficeKB.com" <u43231@uwe wrote in message
news:868978cd33cad@uwe:

In the cell D5 showing the time in the format: 9:23:43 (h:mm:ss), the time
will only update when I click on the cell D5. Therefore, is there any way to
keep "ss" moving without manually click on the cell?

Many thanks for any one advice.
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200807/1