whats the best way do a link to pivot table data.

[sokevin]

if i do a direct reference to the pivot table, and then the pivot tabl
changes, especially when the size of the pivottable, (i.e number o
columns and rows)... then the reference to the pivot table stuffs up.

so wahts the best way to use the data from the pivot table?

cheer

 

[Max]

Try Debra Dalgleish's nice coverage
on dynamic data source for pivot table at:
http://www.contextures.com/xlPivot01.html

 

[Debra Dalgleish]

You can use the GETPIVOTDATA function. There are examples in Excel's
help, and here:

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

 

[Max]

Oops, wrong reading of post, sorry ..
... lucky for me, Debra's on-line at the moment.. <bg>

 

[sokevin]

thanks again.

lots for me to learn

cheers

kev :

 

[Max]

Pleasure' Kev!
Thanks for the feedback

lots for me to learn ..

... this applies to me, too, btw <g>
imo, every post would carry an "implicit" lesson or 2
Cheers