pivot table chart format after update

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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

In article <vlado.xe79n@excelforum-nospam.com>, vlado.xe79n@excelforum-
nospam.com says...
>
> Hi all,
>
> I have the code that connects to external data and created table
> summary in excel. On the next sheet I created pivot table chart which
> also nicely shows important data.
>
> Unfortunately after table update the format is lost and replaced with
> some kind of default format.
>
> Is there any way how to keep format of pivot table chart?
>
> Many thanks
>
> V.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>
>

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Tushar Mehta wrote:

> 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?
>