View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AZSteve AZSteve is offline
external usenet poster
 
Posts: 31
Default Don't refresh tables on Open

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.