| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Refresh child pivot table
In one workbook, I have three parent pivot tables and ten child pivot tables.
I want a macro to refresh these child tables from different parent tables. However I always have debug error in the following code. What did I do wrong here? Set vTableChild = ActiveCell.PivotTable Worksheets(vWSMain).PivotTableWizard SourceType:=xlPivotTable, SourceData:=vTableParent1 Worksheets(vWSChild).PivotTables(vTableChild).Pivo tCache.BackgroundQuery = True Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Parent to Child Data | Excel Discussion (Misc queries) | |||
| VBA code to refresh Child Pivot Table | Excel Discussion (Misc queries) | |||
| Run macro on refresh data (pivot table) | Excel Programming | |||
| pivot table refresh macro | Excel Discussion (Misc queries) | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Threaded Mode
