Updating a PivotTable and PivotChart

You can quickly update a PivotTable report using the PivotTable toolbar, which appears whenever a PivotTable is active. This saves you from having to recreate a PivotTable every time you add new data to a list. When you do want to add new data, Excel makes it easy by allowing you to drag data fields to and from a PivotTable or PivotChart.

Update a PivotTable Report


Make any necessary change(s) in the worksheet where your list range resides.


If necessary, select a different worksheet, and then click any cell in the PivotTable Report.


Click the Refresh Data button on the PivotTable toolbar, or click the PivotTable drop-down arrow on the PivotTable toolbar, and then click Refresh Data.


Add or Remove a Field in a PivotTable or PivotChart Report


Position the pointer over the field that you want to add to or remove from the PivotTable.


Drag the field on the PivotTable to add the field or drag it off the PivotTable to remove the field.


Did You Know?

You can hide and display fields on the PivotTable toolbar . Click the Hide Fields button on the PivotTable toolbar. Click the button again to display the PivotTable fields.

Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net