Run Macro After Pivot Table Refresh

[jtblackburn]

I have a workbook with Pivot Tables on each worksheet. On the "Contact Plan" worksheet, I would like to run a macro I recorded after each time the Pivot Table is refreshed. How can I do this?

I tried putting the macro code into the Worksheet_PivotTableUpdate event for that sheet and it works. However any time I try to refresh a different worksheet pivot table, I get the following error:

Rin-time error '1004':
Select method of Range class failed

How can I fix this?

 

[buxtongt]

It sounds like that event is running for all pivot tables, when you really only want it to run for one. Some options to get around this would be:

1. include an if statement in the macro to determine if a specific tab was active (assuming there is only one pivot table on that tab) and if it is run your macro, if not do nothing

2. add a button on the tab which would refresh the pivot table and then run your macro and have the user just use that button instead of the manual refresh pivot table process.

There might be some other clever ways to handle this that the gurus here can come up with as well. Hope this helps.