If you have Excel 2002 or later, you can use the PivotTableUpdate event
to run the macro. For example:

Private Sub Worksheet_PivotTableUpdate _
(ByVal Target As PivotTable)

'run the formatting macro
FormatPivot

End Sub


Vlado wrote:
Hi everybody,


The loss of formatting is a known problem. There's some info in the
following MSKB article, which suggests using a macro to reformat the table
as required: XL2000: Changing a PivotChart Removes Series Formatting
(Q215904) .
http://support.microsoft.com/default...;EN-US;Q215904

Question:
Is it possible to automatically run macro after changing PivotTable,
instead of run macro manually every time you change PivotTable?


Regards,
Vlado




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html