"Chip Pearson" wrote in message
...
You can use the OnTime method to call a procedure, and that procedure
can then call Refresh on the query tables. See
http://www.cpearson.com/excel/OnTime.aspx for information and example
code for using OnTime and Windows Timers.

Hmm I tried the method using Windows Timer in Excel 2007. I set a cell to
display TimerID (as below) expecting the cell to display a count every
second, but instead it jumped to 30,687 and crashed. Obviously I'm missing
something here 8-)

Any thoughts on what I'm doing wrong?

Many thanks in advance

Sub TimerProc(ByVal HWnd As Long, ByVal uMsg As Long, _
ByVal nIDEvent As Long, ByVal dwTimer As Long)
Range("a24").Select
ActiveCell = TimerID
End Sub