?
Solved

Continuous Recalc in Excel?

Posted on 1998-11-30
4
Medium Priority
?
470 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 200 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

752 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