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

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 a PivotTable

Q1:I've updated data in the list on which my PivotTable is based, but when I view the PivotTable, I don't see the changes. What's wrong?
A1: Click in the PivotTable, rerun the PivotTable Wizard, and check the data source shown in Step 1 to make sure the data source is specified correctly. If you've changed data in the table, you might need to refresh the PivotTable manually—PivotTables don't automatically update with those changes. Position the insertion point anywhere in the PivotTable, right-click, and choose Refresh Data from the shortcut menu. When the data updates, Excel displays a dialog box warning you that the data has changed.

If you've added new fields to the list, those fields might not show up on the PivotTable toolbar until you refresh.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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