Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to Refresh inbound data sheets, then Refresh Pivot Tables | Excel Programming | |||
Refresh Pivot Tables with one hit | Excel Discussion (Misc queries) | |||
Cannot Refresh Pivot Tables | Excel Worksheet Functions | |||
Pivot Tables Refresh | Excel Discussion (Misc queries) | |||
Refresh Pivot Tables | Excel Programming |