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/r...xcelbefore.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/r...Excelafter.jpg
Any help will be welcomed.

Lord Commando Of the Styx

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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 wrote:
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/r...xcelbefore.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/r...Excelafter.jpg
Any help will be welcomed.

Lord Commando Of the Styx



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

On 9 avr, 22:14, Debra Dalgleish wrote:
To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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

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

LordCommando wrote:
On 9 avr, 22:14, Debra Dalgleish wrote:

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTableSelect
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
Contextures
http://www.contextures.com/tiptech.html