Changing Pivot Table Source with Drop-down List

Excel file teaching how to perform Changing the Pivot Table Source with the Dropdown List operation.

Excel Template for Changing Pivot Table Source with Drop-Down List

Data ranges are defined in the drop-down list. The selected range is assigned to the pivot source. The summary table is refreshed after the update. The solution makes multi-page reports easy.

Hope it is useful.