ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Don't refresh tables on Open (https://www.excelbanter.com/excel-programming/436592-dont-refresh-tables-open.html)

AZSteve

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.


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com