Hi Derek.

Have you right clicked the Pivot table, and in Options checked the "Preserve formatting" box?

Don't forget to apply your format to all the rows or columns you want, as some get hidden when you filter the data.


Regards Robert
"More Vodka Please"

"Derek" wrote in message ...
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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.590 / Virus Database: 373 - Release Date: 17/02/2004