Preserving Fornatting in Pivot tables

  • Thread starter Thread starter Chris Whitehead
  • Start date Start date
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
 
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.
 
Back
Top