Special Edition Using Microsoft® Office XP

Troubleshooting

Adding Extra PivotTables

Q1:

I wanted to create a new PivotTable, so I chose Data, PivotTable and PivotChart Report. Instead of starting at the beginning of the wizard, however, Excel started at the third step. Why is this happening?

A1:

You've already created a PivotTable in your worksheet. Because the active cell is within that PivotTable, Excel assumes you want to use the wizard to modify the existing table. To create a new PivotTable, switch to the sheet that contains the list of data you want to use. If you want to create a second or third PivotTable based on the same data as another PivotTable, choose the Another PivotTable or PivotChart option in Step 1; doing so conserves memory and improves performance.

Refresh to Update ...