<div>
hi,<br />
<br />
goto Tool-&gt;Options-&gt;calculation<wbr /> and select automatic ...<br />
<br />
see ya<br />

</div>


hi,

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

see ya


<div>
I need to update continuously...This option will only update when I change a cell. &nbsp; <br />
<br />
I would like it to update on its own about once per second.<br />
<br />
<br />

</div>


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.




<div>
Why do you need to update if no changes have been made??<br />

</div>


Why do you need to update if no changes have been made??


<div>
<div class="content wysiwyg-content">
How can you do a continuous recalc (F9) in Excel.<br />
<br />
I have some time based cells that I would like to see updated once a second. &nbsp;I can update manually using F9.<br />
<br />
How can you update automatically on a continuous basis?<br />
<br />
Thanks,<br />
<br />
Mike<br />

</div>
</div>


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


Continuous Recalc in Excel?

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.