Microsoft Office Tutorials and References
In Depth Information
Analyzing data dynamically by using PivotTables
In the preceding examples, all the field headers are in the Rows area. If you drag the Center
header from the Rows area to the Columns area, the PivotTable reorganizes (pivots) its data
to form a different configuration.
To pivot a PivotTable, you drag a field header to a new position in the PivotTable Fields
pane. As you drag a field within the 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 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 Fields 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 tool tab, in the Data group, click Refresh.