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 PivotT ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.