preserve formatting option in pivot table

T

The Rook

I have formatted a pivot table to the way I would like it and have the
preserve formatting option ticked, but when I refresh the formatting is lost.

Is there anyway of saving it?

Regards
 
Top