Getpivotdata

[cmb80]

Hi all, in the past I have been able to link to the subtotal of a pivot table by clicking the relevant cell and it will say "GetPIVOTDATA" in the formula bar. I am trying to do it today and it just shows the cell value (b55).

Can anyone help enable me to select the GETPIVOTDATA option once again?

[outofthehat]

If you can't get it to do it automatically for you...

GETPIVOTDATA is just a function - have a look at the help file, and you can recreate it as required.