How do I calculate spreadsheet at five minute intervals
 

I have a spreadsheet that retrieves data from an external source. I need to
recalculate the spreadsheet at a regular interval, in this case 5 minutes.
Anyone know a fairly simple way to do this?

How do I calculate spreadsheet at five minute intervals
 

You can use Application.OnTime for schedule a procedure to be executed
at a specific time. See www.cpearson.com/Excel/OnTime.aspx for details
and example code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




On Wed, 11 Feb 2009 13:32:01 -0800, Mel T ID <Mel T
wrote:

I have a spreadsheet that retrieves data from an external source. I need to
recalculate the spreadsheet at a regular interval, in this case 5 minutes.
Anyone know a fairly simple way to do this?

How do I calculate spreadsheet at five minute intervals
 

Chip Pearson shows how to use the OnTime method to run a macro.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP

On Wed, 11 Feb 2009 13:32:01 -0800, Mel T ID <Mel T
wrote:

I have a spreadsheet that retrieves data from an external source. I need to
recalculate the spreadsheet at a regular interval, in this case 5 minutes.
Anyone know a fairly simple way to do this?