When you add a pivot table in previous versions of Excel, the PivotTable and PivotChart Wizard opens
Which guides the user step-by-step in creating the table.
In addition to creating the pivot table, there were other options, such as Multiple Consolidation Ranges,
Or create pivot tables based on a separate cache that no longer appears in the Ribbon versions.
Those of us who want to use the wizard, or its options, can add it to the Quick Access Toolbar:
- Click the arrow on the Quick Access toolbar
- Select More Commands:
- The next window will open:
- Select All Commands
- Highlight PivotTable and PivotChart Wizard
- Click on ‘Add‘
- Finally, click OK
The pivot table wizard will be added to the Quick Access toolbar: