How does one get the PivotTable report info that feeds another PivotTable report?
 

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,
--
Toby Erkson
Oregon, USA
Excel 2003 in Windows XP