I'm sure it has been asked before and seems a pretty simple question, but
can excel automatically refresh (calculate now, F9) ??. i.e. if i wanted to
make a simple clock in excel by entering " =now() " into a cell, could i
then make excel auto calculate this every second so that it keeps up with
current time ??

Cheers
Andy