Extracting from Pivottables

[John James]

Is it possible/practical to extract data from pivottables (apart fro
pivotcharts) and if so how?

Pivottables are excellent in analysing, summarising and drilling dow
on data, but the subsequent presentation and use of that data appear
very restricted and manual based on my current knowledge.

Are there any relevant tricks or tips & if so where

 

[Peo Sjoblom]

Here is one method

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Peo Sjoblom]

Too trigger happy

http://j-walk.com/ss/excel/usertips/tip068.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[John James]

Thanks, Peo.

I hadn't considered using the drill-down facility for this type o
purpose. If the drill-down is more summarised than the original dat
upon which the Pivottable was based, then this has interestin
potential for summarising data through a quick, simple, low-erro
process.

Do you know whether the table produced is a summarised version of th
original data or if it retains all of the original detail? I'm hopin
it is summarised.

In any case, I suspect there might be some potential here because m
recollection is that the drill-down works on any figure in an
pivottable.

Cheers

 

[Debra Dalgleish]

You can use the GetPivotData function to extract data from a pivot
table. There's information in Excel's Help, and here:

http://www.contextures.com/xlPivot06.html