View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vlado Vlado is offline
external usenet poster
 
Posts: 3
Default 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