Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query data within a PivotCache programmatically
I want to be able to query the underlying data within a pivotcache
programmatically. My data source changes daily and I want to be query the data held in the pivotcache snapshot from code. The Recordset property looks promising but so far I haven't had any joy getting anything to work. As drill down is doing what I want to be able to do, are there properties exposed that will allow me to do something similar? I would prefer not to have to set pivottable filters and criteria if at all possible to do the same. Any advice folks? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete programmatically a pivotcache? | Excel Programming | |||
PivotCache Data Source | Excel Programming | |||
Programmatically pass query params | Excel Programming | |||
Re-create source data from pivotcache | Excel Programming | |||
Set a PivotCache as the results of a query | Excel Programming |