Which of the following statements is not true for the
GETPIVOTDATA function?
Use the GETPIVOTDATA function to identify
specific results in a PivotTable, regardless of cell
location.
When you refer to a value in a Pivot Table in
another worksheet, insert a 3D reference to the
target cell.
When the original data referenced in
GETPIVOTDATA is no longer displayed in the Pivot
Table, the function returns an error message.
GETPIVOTDATA displays results from the original
O PivotTable layout as long as that result is still
somewhere in the pivoted version.