How do i can countinuously update time?

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

Guest

The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously.
So, please How i can countinuously update time?
 
Only way would be to run a macro continuously (or periodically) and either
update the cell or cause a calculate. In either case, you will find Excel's
responsiveness will be adversely affected. Obviously running periodically
will be less intrusive

http://www.cpearson.com/excel/ontime.htm
Chip Pearson's page on the use of Ontime
 
You must log in or register to reply here.

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

Check/Uncheck All, write conflict 4
Tabname function 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Save record on lost focus 3
MS Antispyware keeps closing up 14
Error 3260 - Cannot Update record 2
Big chunk(600K to 2MB) continuous data entry 1
Query run automatic update 1

Back
Top