In Excel 2002 and later versions, a GETPIVOTDATA formula is
automatically created when you link to a cell in a pivot table. There
are instructions here for adding the Generate GetPivotData button to a
toolbar, and toggling that feature on and off:

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

When it's turned off, you'll create a normal reference when you click on
a cell in the pivot table. Then you'll be able to copy across or down.

barbb wrote:
How do I use data from a pivot table in a formula outside of the pivot table,
and autofill down?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com