Hi,

This is dependent on what custom formatting you are refering to. There are
work arounds for some of the problems.

One work around is to purchase 2007, this problem has been fixed in most
areas, however there are still workarounds for 2003.

As mentioned you can record a macro which does your custom formatting and
then run it from the

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub

event macro.

If this helps please click the Yes button.

Cheers,
Shane Devenshire

"Germeny Santos" wrote:

How can I format a Pivot Chart and keep the customized format when refreshed?