How to create a dynamic pivot table and refresh automatically

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:

data table

Select the data range.

select data

Click on Insert, and Table.

insert table

Click My Table has Headers.

my table has headers

Click on Insert tab, and choose Pivot Table.

insert pivot table

Click Ok.

create pivot table

Choose the fields on the right.

choose fields

Click on any part of the Power Pivot, Analyze, and Options under Pivot Table Name.

analyze options

Choose Data, and Check on Refresh Data When Opening the File.

refresh pivot table

The Pivot Table will now refresh automatically whenever you open the file.

See also  Count of quarters between dates