Hi all,

Is there a way to get the source data from the pivot cache
for a pivot table? I want to incorporate a search
function with my pivot table so the user can enter a value
and get the related details on a new sheet. It should be
similar to double clicking a subtotal and getting the
details. I can't figure out how to get the data out of
the pivot cache. I can find the PivotItem index for the
PivotField I'm searching, but don't know how to get the
details for rows that match the PivotItem value.


TIA,

John

If you enable drilldown, you can double click in any summary cell and it
will put the detailed records making up that summary on a separate sheet.

As far as I know, you can't pull all the data from the pivotcache like it
was a database. Maybe you can go to the source the cache uses.

--
Regards,
Tom Ogilvy


"John Units" wrote in message
...
Hi all,

Is there a way to get the source data from the pivot cache
for a pivot table? I want to incorporate a search
function with my pivot table so the user can enter a value
and get the related details on a new sheet. It should be
similar to double clicking a subtotal and getting the
details. I can't figure out how to get the data out of
the pivot cache. I can find the PivotItem index for the
PivotField I'm searching, but don't know how to get the
details for rows that match the PivotItem value.


TIA,

John