Changing a PivotChart Removes Series Formatting
 

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

Changing a PivotChart Removes Series Formatting
 

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

Changing a PivotChart Removes Series Formatting
 

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

Thanks Debra and keepitcool
 

It works perfectly.