To prevent old items from being retained in an Excel 2007 pivot table, you can change an option setting, as shown in the short video below: Right-click a cell in the pivot table Click on PivotTable options Click on the Data tab In the Retain Items section, select None from the drop down list. Click [...]

In Excel 2002, and later versions, when you type an equal sign, then click on a cell in a pivot table, you may see a GETPIVOTDATA formula, instead of a cell reference. In this short video, learn how to turn this feature off. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot [...]