Editing and Updating a PivotTable

After you create a PivotTable, it's easy to rearrange fields and data items. Drag fields from one place to another to change the display of data—from a row field to a column field, for example, if you want to see values side by side rather than one above the other. Right-click to display shortcut menus that let you adjust formatting and other options for each field. This section describes common procedures for editing PivotTables.

• To change the list or data source on which the PivotTable is based, click the PivotTable Wizard button on the PivotTable toolbar. Click Back twice to return to the beginning of the wizard and make the required changes, and then click Finish. If you add new rows or columns to a list, you may need to perform this step before the data or fields will be available.