refresh excel

[marcus]

Hello everybody,
Is it possible in excel to display the current time?
I mean, when I put NOW() in a cell and format it to show the time
only, it will work but that time will stay the same untill I close and
open it again. Is there any way to show actual time with seconds
running all the time?

Mark

 

[JE McGimpsey]

You can find a number of methods using VBA in the archives:


http://groups.google.com/advanced_group_search?as_ugroup=*excel*

Note that doing this is pretty resource-consuming. Do you really need it?