Automatically Refresh Pivot Table Data
 

How can a pivot table refresh data automatically while the file is open and
the data is changed without me having to hit the refresh data button?

Automatically Refresh Pivot Table Data
 

On Feb 25, 4:11 pm,
wrote:
How can a pivot table refresh data automatically while the file is open and
the data is changed without me having to hit the refresh data button?

Hi pmyers123,
you probably need a VBA macro. Have a look at http://www.ozgrid.com/VBA/pivot-table-refresh.htm

Cheers Michael