It's annoying the way the pivot chart destroys all your carefully chosen
formatting every time it refreshes.
Perhaps, just before you refresh, you could copy the formats to an empty
sheet, then copy them back again onto the pivot table after the refresh?
Perhaps the clever folk who know VBA could even arrange for a macro to
do it automatically?
