Pivot Tables - Custom Format

[Dan The Man]

I am trying to format a pivot table to a my own specification.

I have disabled autoformating and enabled the option to keep the users format. However, for some reason it decides to apply some of my shading and boarders but not all - that is, after i refresh the pivot table.

It is hard to describe my problem but some rows keep their format while others that should behave the same don't.

Does anyone have an idea what is going on, because i don't.

 

[mrhartley]

Hi,

There is a tick box for preserve formatting, have you tried this?

Right click PT - Table Options.

Otherwise, sorry I have no more ideas.
Regards
~Mark