Automatically duplicate your Pivot Tables with different selections

Automatically duplicate your Pivot Tables with different selections

An overlooked feature is the ability to (automatically) have Excel create a number of new sheets with Pivot Tables in then, named with the selection chosen and the filter switched onto that selection

To follow along in your Excel Download File go to 5.2 Duplicate Reports

The key lessons from this video are:

  • Needs to be accessed via the ANALYSE┬áTAB and the OPTIONS drop down (not the button, but the dropdown)
  • You must have fields in the Filters
  • You can only choose one of them
Back to: Pivot Tables in Excel > Report Filter in Pivot Tables