Make pivotchart formatting stick after pivottable refresh.

After setting custom pivotchart patterns the patterns are reset to default
after underlying pivottable is refreshed. How can we make the custom
patterns remain in place after pivottable refresh?

Hi,

Known bug: See MSKB article, XL2000: Changing a PivotChart Removes
Series Formatting (Q215904) .
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

larry garka wrote:
> After setting custom pivotchart patterns the patterns are reset to default
> after underlying pivottable is refreshed. How can we make the custom
> patterns remain in place after pivottable refresh?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info