GETPIVOTDATA Turn Off

[DG]

How do you stop the GETPIVOTDATA function. When I create pivot tables if I
want to work with data within the table this function makes it impossible

Example:

Table Result Formula

Sum of Count
Animal Total
Cats 7 14 =GETPIVOTDATA("Count",$I$10,"Animal","Cats")*2
Dogs 8 14 =GETPIVOTDATA("Count",$I$10,"Animal","Cats")*2
Elk 3 14 =GETPIVOTDATA("Count",$I$10,"Animal","Cats")*2
Grand Total 18



It dosen't matter if I change the $ reference locks, the results stay the
same. I have to go in and manually chage the text "cats" to "dogs" to get
the results I'm after which defeats the purpose of a spreadsheet.

 

[Ken Wright]

View / Toolbars / Pivot tables / Find the GetPivotdata button (May have to add
it) and hit it. It's a toggle switch.

 

[Debra Dalgleish]

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