H
HKS
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).PivotCache.BackgroundQuery =
True
Thanks
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).PivotCache.BackgroundQuery =
True
Thanks