Solved

Continuous Recalc in Excel?

Posted on 1998-11-30
4
465 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

825 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