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

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