T
Toby Erkson
A pivot table can get it's data from another pivot table as so:
Right click in the pivot table and select PivotTable Wizard
Click the < Back button
Click the next < Back button
Select the "Another PivotTable report or PivotChart report" radio button and
click Next >
Select the pivot table and click Finish
What I want to get is the source pivot table for a pivot table. I guess I'm
looking for the "parent" of the "child" pivot table
How can I do this in
VBA?
Here's the macro recording of the above steps but it didn't help me for
reading the SourceData in other code I tried:
Sub Macro1()
ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:=
"PivotTable4"
End Sub
It appears to me that PivotTableWizard cannot be used to read the above
SourceData property from what I've tried :-( When I pull the SourceType it
returns xlExternal (2), not xlPivotTable (-4148) as I would expect.
TIA,
Right click in the pivot table and select PivotTable Wizard
Click the < Back button
Click the next < Back button
Select the "Another PivotTable report or PivotChart report" radio button and
click Next >
Select the pivot table and click Finish
What I want to get is the source pivot table for a pivot table. I guess I'm
looking for the "parent" of the "child" pivot table
How can I do this inVBA?
Here's the macro recording of the above steps but it didn't help me for
reading the SourceData in other code I tried:
Sub Macro1()
ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:=
"PivotTable4"
End Sub
It appears to me that PivotTableWizard cannot be used to read the above
SourceData property from what I've tried :-( When I pull the SourceType it
returns xlExternal (2), not xlPivotTable (-4148) as I would expect.
TIA,