GETPIVOTDATA in other languages:

The German translation of the Excel function GETPIVOTDATA is:

EnglishNederlands
GETPIVOTDATA

Description

Returns data stored in a PivotTable report. You can use GETPIVOTDATA to retrieve summary data from a PivotTable report, provided the summary data is visible in the report.

 Note   You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return.