How do I calculate spreadsheet at five minute intervals

  • Thread starter Thread starter Mel T ID
  • Start date Start date
M

Mel T ID

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averaging lines of data at every ten lines 5
Excel MS Excel - MS Office 2010 0
Interpolating data timepoints 3
Averaging an interval of data 2
Inserting Multiple Rows into Spreadsheet 1
Excel Excel spreadsheets opening at top instead of bottom. 4
How do I stop a recalculation in Excel? 6
Copy last data entered into mulitiple sheets within a workbook? 2

Back
Top