Don't refresh tables on Open

  • Follow


When I open a particular workbook that has two Query Tables, I don't want the 
message to appear that asks if I want to refresh the data.  It should be 
"Don't Refresh" because I have macros that will do that at the appropriate 
time.

This does not prevent the question on opening the workbook >

Private Sub Auto_Open()
Sheets("Data").QueryTables(1).RefreshOnFileOpen = False
Sheets("Data").QueryTables(2).RefreshOnFileOpen = False
End Sub

Please help.
0
Reply Utf 11/24/2009 8:35:03 PM


0 Replies
214 Views

(page loaded in 0.058 seconds)


Reply: