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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top