Similar to other users I have been experiencing problems with preserving the
formatting on refresh in a pivot table. The "preserve formatting" option is
selected and so too is the "enable selection". All fields are preserved with
exception to one particular troublesome field. Does anyone have any further
suggestions to resolve this issue?

Kind Regards.