Appending Data to an existing pivot table

[MAF]

Is there any way to append data to an existing pivot table

 

[Patrick Molloy]

Yes. If the source is a rangenamed table, then you need only add new rows
then extend the range. Update the pivot table to renew the pivot values

 

[Frank Kabel]

Hi
for a dynamic pivot table source have a look at
http://www.contextures.com/xlPivot01.html

 

[MFRASER]

Thanks for the example. I am not able to view my data because I am doing
the following

Dim pCache As Excel.PivotCache
Dim pTable As PivotTable

Set pCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal)
Set pCache.Recordset = rst
Set pTable = pCache.CreatePivotTable(sheet.Range("A8"))

Set AddPivotTable = pTable

Is this not the correct way to setup the pivottable?

 

[MFRASER]

I was able to create two Pivot tables on the same sheet I would like to
create a third that containst the data fo the other two pivot tables, is
this possible?