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