Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Continuous Recalc in Excel?

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
mgerard
Asked:
mgerard
1 Solution
 
pjmazeCommented:
hi,

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

see ya
0
 
mgerardAuthor Commented:
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
 
jboddyCommented:
Why do you need to update if no changes have been made??
0
 
carttiCommented:
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now