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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field Formatting in Pivot Tables 1
Pivot Table formatting 2
Excel VBA For excel 0
Pivot Table Formatting 1
Pivot Table Format Preservation 1
pivot table formating 1
I am having trouble keeping numbers formatted in a Pivot Table 1
grouping multiple tables Excel 2007 3

Top