MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Recalc


Posted by John Yuga on May 15, 2001 9:45 AM


Hello,
How can I make Excel aoutomaticly recalculate a value in a cell at a set interval, say 100 times a minute or any frequency I want?

An example would be helpful.

Thanks
John Yuga jyuga@home.com


Posted by Kevin James on May 15, 2001 10:53 AM

Hi John:

Tools / Options, Calculation tab.

You can set the calc to manual or automatic. If it is automatic, then it is "live" (immediate)updates. To my knowledge (I've been wrong so many times its embarrassing) there is no way to set calc to fractions of time.

Kevin

Posted by Dave Hawley on May 15, 2001 3:34 PM

Hi John

You would need to use VBA for this.

"Application.Ontime" method calling another OnTime procedure. This would basically render your Workbook unusable though as it would be constantly recalculating.

Dave

OzGrid Business Applications