How do I turn OFF the GETPIVOTDATA function?

  • Thread starter Andrew at Uni of Technology Sydney
  • Start date
A

Andrew at Uni of Technology Sydney

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.
 
K

Ken Wright

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