Several readers have submitted questions about Excel 2010 and 2007 PivotTables, as follows: Q1: Why does Excel insert the GETPIVOTDATA function into a formula when you use the mouse pointer to refer ...

Pivot Tables, Grouping, Multi-level Pivot Tables, Multiple Report Filter Fields, Frequency Distribution, Pivot Charts, Slicers, Calculated Field/Item, GETPIVOTDATA function - Kuba27x/Excel-17 ...

In this case, Excel automatically inserts the GETPIVOTDATA function into your formula, as shown below in cell D2. As a result, the formula cannot be properly copied with relative references to ...

A new GETPIVOTDATA function makes it easier for users to pull information out of a pivot table, as well.