![]() |
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