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

Troubleshooting

Adding Extra PivotTables

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?

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