Pivot Table format preservation

[JATOMSETT]

Excel 2010. How do I retain my pivot table formatting, which is lost every time I select a different criteria from the report filter, even though I have ticked the 'preserve cell formatting on update' & then updated?

 

[JATOMSETT]

No I don't have 'Autofit column widths on update' checked. So is there an equivalent 'Autofit row height on update' option somewhere?

 

[RoryA]

No - I was just wondering if that option might be affecting you (as I said, I can't reproduce your issue)

 

[JATOMSETT]

Sorry! Are you saying there isn't an 'Autofit row height' option anywhere that I can switch off?

 

[RoryA]

No, there isn't, I'm afraid.

 

[JATOMSETT]

Gloom & Doom! However thank you for your time & you did solve the colour problem for me.