Locking Formats in Pivot Table Excell 2007

[admack]

Hi,

I am trying to lock down formatting in a pivot table within Excel 2007. I would like to retain all formatting i.e. colours, font, column width etc - is this even possible?

I have hunted high and low and the answer seems to be to make sure that "preserve formatting on refresh is selected" - thing being that I have this selected and it doesn't retain formats (which somewhat defeats the purpose)

Any help would be greatly appreciated.

A

 

[Derek Brown]

You can use Conditional Formatting to overcome some of the problems - details in:
MrExcel's Learn Excel #875 - Conditional Pivot Formatting - YouTube