• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Adding Extra PivotTables

You want to create a new PivotTable, so you choose Data, PivotTable and PivotChart Report. Instead of starting at the beginning of the wizard, however, Excel starts at the third step. You can click the Back button to start over, but why is this happening in the first place?

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint