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?

 

[RoryA]

What formatting are you talking about specifically?

 

[JATOMSETT]

Changes in row heights & 'fill colour' are the main problems when I refresh my data or select a different option with the report filter. I want to use the results in a presentation & need to know I will get a constant result.
Any help would be much appreciated.

 

[RoryA]

Row heights apply to entire rows, not cells, so I don't think you can get that to work but colour fills should remain with whichever item you applied them to.

 

[JATOMSETT]

Row Heights: If I change the row height in an ordinary Excel worksheet & save it, it remains the new height when I reopen the worksheet. So I don't understand why it is not happening in a Pivot Table Row.
Fill Colour: these are either cells or rows & the colour of some of them resorts back to the 1st colour I used before changing to a 2nd colour.
My preserve cell formatting on update is definitely on.

 

[RoryA]

I can't replicate either of those behaviours. Do you have SP1 installed?

 

[JATOMSETT]

No! So I have now installed SP1 (after 2 failed attempts) & the 'fill colour' problem is resolved - brilliant & thank you so much.
However, it didn't fixed the row height, which just reverts to the default 15, every time I refresh data / change report filter criteria / or reopen the work book.

 

[R Pelle]

Try-
Rightclick your Pivot
Pivottable options, Layout and Format tab, put a tickmark in Preserve Formatting on Update.


Rob

 

[JATOMSETT]

Thankyou, but I did that at the beginning and it is still selected.

 

[RoryA]

Do you have Autofit column widths on update checked?