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 ...

You click outside of the pivot table. You build an Excel formula. You copy this formula down to all of the rows in the pivot table. The calculation reports the wrong answer for all but the first row ...

The problem arises when you use your mouse to write a formula that references a cell in a PivotTable. In this case, Excel automatically inserts the GETPIVOTDATA function into your formula, as shown ...

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

A new GETPIVOTDATA function makes it easier for users to pull information out of a pivot table, as well. People who rely on Sheets for creating charts also got a few extras, including the ability to ...