I often want to reference a cell value in a pivot table by simply clicking on
the cell (rather than typing in the cell reference) usually to use in a
separate formula. I could do this in previous versions of Excel. In the
current version of Excel I get the GETPIVOTDATA function which includes
absolute cell references which means I cannot drag the formula down. This is
quite minor but also enfuriating.

View / Toolbars / Pivot Table / Click on 'Generate PivotData' icon to toggle
function on/off

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Andrew at Uni of Technology Sydney" <Andrew at Uni of Technology
wrote in message
...
I often want to reference a cell value in a pivot table by simply clicking
on
the cell (rather than typing in the cell reference) usually to use in a
separate formula. I could do this in previous versions of Excel. In the
current version of Excel I get the GETPIVOTDATA function which includes
absolute cell references which means I cannot drag the formula down. This
is
quite minor but also enfuriating.

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

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


Andrew at Uni of Technology Sydney wrote:
I often want to reference a cell value in a pivot table by simply clicking on
the cell (rather than typing in the cell reference) usually to use in a
separate formula. I could do this in previous versions of Excel. In the
current version of Excel I get the GETPIVOTDATA function which includes
absolute cell references which means I cannot drag the formula down. This is
quite minor but also enfuriating.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html