pivot table chart format after update

[vlado]

Hi all,

I have the code that connects to external data and created tabl
summary in excel. On the next sheet I created pivot table chart whic
also nicely shows important data.

Unfortunately after table update the format is lost and replaced wit
some kind of default format.

Is there any way how to keep format of pivot table chart?

Many thanks

V

 

[Tushar Mehta]

Intentionally or otherwise, PivotTables and PivotCharts don't retain
all their user-specified formatting after a refresh. Check the MSKB
for more on the subject.

In the meantime, if you are doing the refresh programmatically, why not
have the code fix up the format as desired?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Microsoft admits there's a problem with this, and suggests that the user
record a macro to reapply the desired formatting.

XL2000: Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/?id=215904

Reason number 17 to avoid pivot charts, and base a regular chart on the
pivot table data.

- Jon