Changing a PivotChart Removes Series Formatting

[Vlado]

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.aspx?scid=kb;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]

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

 

[keepitcool]

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]

It works perfectly.