View Single Post
  #4   Report Post  
Bill Manville
 
Posts: n/a
Default

I think you would have to mark the queries as not running on startup
and then have a startup macro that runs them.

Sub Auto_Open()
Dim WS As Worksheet
Dim QT As QueryTable
For Each WS In ThisWorkbook.Worksheets
For Each QT In WS.QueryTables
QT.Refresh BackgroundQuery:=False
Next
Next
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup