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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous updating of date and time fron function NOW() 0
VBA word change keys 0
Paragraph numbering in Word 1
How to automate update on weekly reports spreadsheet 0
FN key 3
Ctrl-a, F9 doesn't work to update all fields including TOC 6
Embed the same Excel multiple times 0
Integrating information from Word to Excel (not mail merge) 1

Top