Pivot Table - Preserve Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If the formatting suggestions from other posts haven't worked, you could
record a macro as you refresh the pivot table, and reformat the field.
Then, run that macro as required.
 
You must log in or register to reply here.

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

Pivot Table formating 2
Pivot Tables and Formatting 2
Excel VBA For excel 0
Pivot table column help 2
Pivot Table formatting 1
How do I keep with column widths of a pivot table when I refresh 1
Pivot Tables 1
Pivot Table Format Preservation 1

Back
Top