Run code after pivot table refreshes

[kc.crow]

Hi,

Is there a way to capture a refresh or filter applied to a PivotTable as an event with which to attach code? PivotTable refreshes tend to remove formatting of column headers and was looking for a way to either set the formatting up so that I could keept it or have code re-apply the formatting.

Hopefully one of the geniuses out there can help.

[Bob Phillips]

Why don't you add a button and refresh the pivot from within the macro assigned to that button. You can add whatever code you like then.

[kc.crow]

Thanks for the reply.

I can do that but was hoping for something a little more automated like and event handler for the filters. Any thoughts on that?

[Bob Phillips]

There is no pivot refresh event that you can hang on to.