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

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

you're less likely to lose pivot table or chart formatting if you base the
pivot on a (dynamic) named range..


As long as you dont delete, but edit the name object, the pivot will not
notice that the "source object" has changed..

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"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

It works perfectly.