Syntax. GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,...)

Definition. This function returns data from a PivotTable report. You can use GETPIVOTDATA() to retrieve summary data from a PivotTable report as long as the summary data is visible in the report.


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


  • data_field (required) The name, enclosed in quotation marks, for the data field that contains the data that you want to retrieve.

  • pivot_table (required) A reference to a cell, cell range, or named cell range in a PivotTable report. This information ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.