Preserving Fornatting in Pivot tables

C

Chris Whitehead

I run quite a lot of pivot tables and update them
regularly.

I am struggling to preserve the formatting on them. When I
refresh the table they lose some or all of the formatting.

I have played about with table options - Autoformat &
preserve formating but without any success...

Any suggestions

Chris
 
K

Ken Wright

Pick on one of the fields in the data area that has a value in it. Right click and choose Field
settings / Number / Choose a format, hit OK, and it should be retained.
 
Top