Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing pivot table ADO recordset
Hi fellows,
I've created a pivot table from an ADO recordset. (No problem in that) like in this code: Dim rs As New ADODB.Recordset rs.open ........ Dim pc As PivotCache Set PC=ThisWorkbook.PivotCaches.Create(....) Set pc.Recordset = rs pc.CreatePivotTable(...) The problem is: If the source data has changed and I want to transfer these updates to the pivot table (and its pivot cache). How can I tell the pivot table (or its pivot cache) to use another updated ADO recordset? I do not want to re-construct a new pivot table each time there are changes in the source data, Just updating the data (or the recordset) in the first pivot table. Also I do not want the trivial solution that is pasting the recordset contents into a worksheet using rs.CopyFromRecordset and then use the pasted range as a source for a permanent pivottable. I just want to throw a new recordset into the pivot table (or its pivot cache) directly. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need code assistance to update pivot table from an ADO recordset | Excel Programming | |||
Creating Pivot Table from a DAO recordset | Excel Programming | |||
pivot table from recordset - very slow performance | Charts and Charting in Excel | |||
reusing a recordset for a pivot-table? | Excel Programming | |||
reusing a recordset for a pivot-table | Excel Programming |