I have an existing PivotTable. Now i want to modify it by adding 1 more Row field. Here's the VBA code:
The new row is added, but somehow all existing rows and filters are removed. From the documentation, if AddToTable is True, none of the existing fields will be replaced.
Am i missing anything here ?
Code:
pvTbl.AddFields RowFields:="Company", AddToTable:=True
The new row is added, but somehow all existing rows and filters are removed. From the documentation, if AddToTable is True, none of the existing fields will be replaced.
Am i missing anything here ?