Solved

Continuous Recalc in Excel?

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
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 templates, what they are used for, and how to create and save a custom template using Microsoft Word.
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…

726 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