Don't refresh tables on Open

A

AZSteve

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Refreshing Querytables. 8
Invalid Web Query Error 6
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Help with VBA Macro needed 3
How to re-fresh the import links if it fails? 1
how delete old querytables? 2
Reset QueryTable error on empty text file 1
Connecting Questions on Querytables 1

Top