Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Code To Refresh Query Table
I am trying to refresh data in a query table but the following code does not
work: "Selection.QueryTable.Refresh BackgroundQuery:=False". If I just right-click on the cell containing the querry and select "Refresh data" from the menu it works fine but this must be automated. Please advise if anyone knows the correct code. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
Formula Help | Excel Worksheet Functions | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Pivot table refresh | Excel Worksheet Functions |