On Mar 19, 12:30*pm, wrote:
On Mar 19, 11:14*am, Maggie wrote:

I have a worksheet that is constantly changing and I want my pivot
table to change when my worksheet changes automatically without having
to hit the refresh button. *Is there a macro out there that will do
that?

Maggie,

If you run the macro recorder to get the code for a pivot table
refresh you will get something similar to the following:

ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh

You can have this run after your "worksheet changes automatically."

Best,

Matt Herbert

That did not work when I tried that. Is there anything else that is
possible?