To create a dynamic Pivot Table that refreshes automatically, you need to start with data in a table format. The table must have headers, and the data must be in a consistent format.
Creating a dynamic Pivot Table
Creating a dynamic Pivot Table that refresh automatically begins with this kind of data:
Select the data range.
Click on Insert, and Table.
Click My Table has Headers.
Click on Insert tab, and choose Pivot Table.
Click Ok.
Choose the fields on the right.
Click on any part of the Power Pivot, Analyze, and Options under Pivot Table Name.
Choose Data, and Check on Refresh Data When Opening the File.
The Pivot Table will now refresh automatically whenever you open the file.
