Is there a way to automatically run a reformatting macro when a pivot chart
has changed after a selection has been made from a PivotField? I have added
a button to trigger the macro but it would be neater without the need for
this.

Thanks