Hi All,
I have a pivot table from wich I am trying to get Customs Subtotals using the GetPivotData function.
This is the calls from an Excel Formula, which works well.
=GETPIVOTDATA($C$4,"ModelId['100233';Sum] EQ_EUROPE")
$C$4 = is the top left cell of the PivotTable
How can I get this to work form VBA?
This code here, where Pvt is a PivotTable object pointing to the righ Pivot Table does not work!
Pvt.GetPivotData(""ModelId['100233';Sum] EQ_EUROPE")
Thanks
I have a pivot table from wich I am trying to get Customs Subtotals using the GetPivotData function.
This is the calls from an Excel Formula, which works well.
=GETPIVOTDATA($C$4,"ModelId['100233';Sum] EQ_EUROPE")
$C$4 = is the top left cell of the PivotTable
How can I get this to work form VBA?
This code here, where Pvt is a PivotTable object pointing to the righ Pivot Table does not work!
Pvt.GetPivotData(""ModelId['100233';Sum] EQ_EUROPE")
Thanks