How do I have Excel continuously update as if holding F9 down?

A

AW 11753

I can inset the NOW function but it will only update if I press F9. I want to
have it continuously update without pressing F9. How do I do that?
 
A

Alan

What I believe you are asking for is a working clock in an Excel workbook.
This can be done using VBA code but its not a good idea. Its slows or stops
all other functions while its running making the workbook virtually useless
other than to read only.
Regards,
Alan.
 
Top