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.