Microsoft Office Tutorials and References
In Depth Information
To pivot a PivotTable, you drag a field header to a new position in the PivotTable Field List
task pane. As you drag a field within the task pane, Excel displays a blue line in the interior
of the target area so you know where the field will appear when you release the left mouse
button. If your data set is large or if you based your PivotTable on a data collection on
another computer, it might take some time for Excel to reorganize the PivotTable after a
pivot. You can have Excel delay redrawing the PivotTable by selecting the Defer Layout
Update check box in the lower-left corner of the PivotTable Field List task pane. When
you’re ready for Excel to display the reorganized PivotTable, click Update.
If you expect your PivotTable source data to change, such as when you link to an external
database that records shipments or labor hours, you should ensure that your PivotTable
summarizes all the available data. To do that, you can refresh the PivotTable connection
to its data source. If Excel detects new data in the source table, it updates the PivotTable
contents accordingly. To refresh your PivotTable, click any cell in the PivotTable and then,
on the Options contextual tab, in the Data group, click Refresh.