Formatting lost in a Pivot Table after a data refresh

[LordCommando]

I designed a Pivot table to look at various data, with 2 fields in the
column section. The information is perfectly accurate, but because of
the quantity of information, I have to set a specific alignment for
readability for the 2 fields. If I add information and refresh, I'm
loosing a portion of my formating. What should I do?

Take a look at these 2 images for a better idea of the problem:

http://i141.photobucket.com/albums/r66/LordCommando/Excelbefore.jpg
first image, look at line 4, properly aligned.

second image after refresh, line 4 is not the same anymore. sniff
http://i141.photobucket.com/albums/r66/LordCommando/Excelafter.jpg
Any help will be welcomed.

Lord Commando Of the Styx

 

[Debra Dalgleish]

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings
Format the selected headings

 

[LordCommando]

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings
Format the selected headings

I does work, I tried it but the change is not permanent. If I refresh
again, I will lose formatting again, back to square one... Maybe
I'm missing something...

Lord Commando Of The Styx

 

[Debra Dalgleish]

Right-click on a cell in the pivot table and choose Table Options
Make sure that the Preserve Formatting box is checked.