Retrieving Source Data From Pivot Table

J

John Units

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
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table: Determining item from one field based on anotherfield item 0
Pivot table - unwanted lines 2
Pivot Table Filtering - Macro 3
Changing pivot table ADO recordset 0
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
Pivot Table Macro, exclude possible blanks 0
remove/delete/hide/exclude all (Blanks) in a pivot table macro 3
Change SourceName on Pivot Table 0

Top