In Excel 2003, you could drag fields from the PivotTable Field List onto the pivot table layout on the worksheet. In Excel 2007, you can only move the fields to the areas in the PivotTable Field List. In the screen shot below, if you try to drag the Promo field onto the pivot table, the [...]

Occasionally, you might need to change a column heading in the pivot table’s source data. For example, you could change a column heading from Qty to Quantity, to make it easier to understand. However, when you refresh the pivot table after making the changes, the renamed field will disappear from the pivot table layout. In [...]