Solved

Continuous Recalc in Excel?

Posted on 1998-11-30
4
464 Views
Last Modified: 2012-08-14
How can you do a continuous recalc (F9) in Excel.

I have some time based cells that I would like to see updated once a second.  I can update manually using F9.

How can you update automatically on a continuous basis?

Thanks,

Mike
0
Comment
Question by:mgerard
4 Comments
 
LVL 2

Expert Comment

by:pjmaze
ID: 1614717
hi,

goto Tool->Options->calculation and select automatic ...

see ya
0
 

Author Comment

by:mgerard
ID: 1614718
I need to update continuously...This option will only update when I change a cell.  

I would like it to update on its own about once per second.


0
 
LVL 5

Expert Comment

by:jboddy
ID: 1614719
Why do you need to update if no changes have been made??
0
 
LVL 2

Accepted Solution

by:
cartti earned 50 total points
ID: 1614720
I have to go along with jboddy on this one though here is the answer:

Initialise this only once:

Sub ReCalc()
Dim Start_Time

Application.Calculation = xlManual
Start_Time = Timer
Do
      DoEvents
      If Start_Time <= Timer Then
          Application.Calculate
          Start_Time = Timer + 1
      End If
Loop
End Sub
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now