DYNAMIC DATA IMPORT function

Category:Search and reference

English name:GETPIVOTDATA

That makes?

Returns visible data from a PivotTable report.

Syntax

DYNAMIC DATA IMPORT (data_field, dynamic_table, [field1, element1, field2, element2],…)

  • data_field (Required ): Name of the data field from which the information will be extracted.
  • dynamic_table (Required ): Cell or range in the pivot table that contains the data to retrieve.
  • field1, element1: (Optional ): Pair of name and field that describes the data to be retrieved. A maximum of 126 pairs can be specified.

Examples

DYNAMIC DATA IMPORT (“Sales”, $ A $ 5) = Extracts the value of cell $ A $ 5 from the Sales data field of a pivot table.

Leave a Comment