work with data behind pivot table

[cebco75]

hello--

I'd like to use a pivot table as a selection/segmentation tool for a relatively large (5 million row) database.

The default action for double-clicking on a data item cell is to dump the "data behind" contents into a new excel worksheet. That works fine as long as the # of rows doesn't exceed the 65k excel limitation.

What I'd like to do is to stop that default double-click action and redirect it so that the contents dump into an access table or csv file.

any ideas? thanks in advance!

 

[SkipVought]

You have your 5M row database.

This can be your source data. It does not need to reside in Excel. The PT is in Excel, not the source data.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[cebco75]

i'm trying to use the pivot table as a selection tool into the 5M row database. so...say i've sliced/diced my data using the pivot table and of the 5M records, i can see that 66000 records reside in the U.S. and purchased $3000 worth of product XYZ during 10/2004...i want to extract those records to an Access database or other external file directly from the pivot table and not use sql to do it.

does that make sense?

 

[SkipVought]

Well, going back to the original question, I don't believe that there's any way to CHANGE the double-click feature in a PT.

However, you could write a procedure that takes that double-click result and stuffs it into an Access table -- not for the faint of heart or little of know-how.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[cebco75]

thanks for the interest Skip...that's exactly what i was getting at. i'm trying to get at the result of the double-click and from all the PT documentation i've read at msdn and through the help topics (and playing with the macro recorder), i can't figure out how to isolate it or what the result is even called.