GetPivotData?

[BittenApple]

Hello team,

I have a pivot table, the headers are:
RowLabel, Num1, Num2, Num3, Num4
I should be able to create getpivotdata by typing getpivotdata and selecting a cell inside the pivot tale.
It gives me =GetPivotData(A39, c45), I don't have a name for my pivot table.

What is the suggestion?
Regards,
Bita

[HansV]

Instead of typing =GETPIVOTDATA(, type just = and then click on a cell in the pivot table.

[BittenApple]

I did and it worked for me.
What happened to getpivotdata? I have office 365.
Thanks for all,
Blue

[HansV]

If you type =, then click in a cell in the Values area or in one of the (sub)totals, Excel should automatically create a GETPIVOTDATA formula. It won't do that if you click in other cells of the pivot table, for example a row or column field.

But there is a setting to disable GETPIVOTDATA:
- Select File > Options.
- Select Formulas in the navigation pane on the left hand side.
- Under 'Working with formulas', there is a check box 'Use GetPivotData functions for PivotTable references'.
- If this check box is clear (not ticked), Excel wlll not create a GETPIVOTDATA formula if you click in a pivot table.

S0437.png

[BittenApple]

Hello Hans,
I did, but it was not getting me any GetPivotData when I click on the cells of my pivot table.
Regards,
Bita