Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing Query Tables
hi,
try this ActiveWorkbook.RefreshAll -----Original Message----- I am trying to run a macro to refresh all query tables in my sheet. I am using the following code, but it does not seem to update the tables, but it doesn't error out either. any ideas? For Each ws In Worksheets ws.Activate For Each query In QueryTables query.Refresh BackgroundQuery:=False Next Next . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing an Excel Query | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables | Excel Worksheet Functions | |||
Refreshing Data from a web query | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables QUery | Excel Programming |