Sheet Auto-Update

[JHughes]

I'm using the NOW() function on a spreadsheet Im creating and want to know how to get it to count up realtime without me having to hit the F9 key. Is this just a setting in Excel or does anyone have a program that will literlly press the F9 every second?

 

[Oaktree]

You will need to use a macro.

Have a look at the OnTime method in VBA help...