medium10 pts · first answer countsexcelpivot-tables

A strange GETPIVOTDATA formula

You type = and click a cell inside a pivot table. Instead of =B5, Excel writes =GETPIVOTDATA("Sales",$A$3,"Region","West"). Why?

A.The pivot table cell is protected from all direct cell referencesB.The pivot has an error and needs to be rebuiltC.It fetches the value by labels, so it survives layout changesD.GETPIVOTDATA is needed to round pivot values

Discussion 0

Join free to post in the discussion.

A strange GETPIVOTDATA formula

Discussion 0

Related questions