In article ,
says...

I have succeeded doing this in several workbooks, but I
can't repeat it each time in the same way.

Why not?

Also, have you seen the articles below and other related ones at
support.microsoft.com?

XL97: Formatting Not Retained in PivotTable
http://support.microsoft.com/default...b;en-us;162028

XL: PivotTable Refresh Overwrites Formatting
http://support.microsoft.com/default...b;en-us;110602

--
Regards,

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

In article ,
says...
This must be a tough one, if none of the MVP's can answer
it.
*****************
Again .. (3rd attempt!)
In Excel 97, how to apply formatting inside a Pivot table
that remain after refreshing?

I have succeeded doing this in several workbooks, but I
can't repeat it each time in the same way.

thanks to anyone that can solve this question,
Derek