Pivot table formatting retention post refresh

R

rconley17

New Member
Joined
Mar 2, 2007
Messages
32
Hi there,

Created a Pivot Table.
1)The Column header text label appears in White Font on a White backround.
2) Headers length is quite long. Prefer the header outputs in a 90 degree alignment.

I make these changes, refresh and they do not maintain. The Pivot Table OPTIONS menu shows Preserve Formatting as checked. I have tried to deselct and reselct this options without success.

Thanks in advance for the help.
Ryan
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
Hi - 'preserve formatting' preserves the number formatting of the source data, not the format of the pivot itself. (to demonstrate, format some data as %, then run a pivot from the data with the 'preserve formatting' option off).

It is an unfortunate 'feature' of pivots that customization is lost on refresh - the standard solution is to record a macro of yourself applying the formatting you want, then run it after the pivot refresh.
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
Pivot Table does not preserve formatting on refresh
Replies
7
Views
1K
lafoug
L
W
  • Solved
Formatting pivot table data
Replies
5
Views
390
GlennUK
G
A
  • Question
Pivot Table Format Query
Replies
0
Views
287
Arts
A
P
  • Question
Pivot Table Font, Font Size, Background Color Changes while refreshed.
Replies
0
Views
962
Prince0160
P
M
  • Question
Keep Column order with changing column names when exporting to Excel and preserve cell formatting
Replies
0
Views
677
MichaelSchulz
M

Forum statistics

Threads
1,214,661
Messages
6,120,796
Members
448,994
Latest member
rohitsomani

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top