Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Report - NEW USER | Charts and Charting in Excel | |||
How to refresh a Scenario PivotTable Report? | Excel Discussion (Misc queries) | |||
Report Filter in PivotTable | Excel Discussion (Misc queries) | |||
How do I run a pivottable report w/ multiple worksheets? | Excel Discussion (Misc queries) | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |