Use the macro recorder to capture the formatting commands.

Here is a great resource for all things pivot tablely!
http://www.contextures.com/xlfaqPivot.html

Cheers
Andy


Nir wrote:
thanks Andy,
does MS supply any add-in for or just record it on my local report?
thanks


"Andy Pope" wrote:


This is a known bug that requires vba code to re-apply formatting.

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

Cheers
Andy

Nir wrote:

I want to keep changes to format i performed in a pivot chart, that would not
be affected upon refresh table.

thanks\


--

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


--

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