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

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



Goalie35 wrote:
I had to edit a pivot table to accomodate a change in the excel report
columns however I'm unable to save any formatting I've performed on the
column headers.

I have a pivot table that is reading data from another worksheet. I had to
add a few columns to the source worksheet, so therefore, the pivot table
columns automatically changed as well. Unfortunately though, the pivot table
column headers did not inherit the propper cell background colors. My source
worksheet uses yellow for the header backgrounds however the new headers in
my pivot table contain purple by default. Every time I switch the background
color of these headers and then refresh the data, the color simply switches
back to purple again.

How can I fix this to display the propper colors?

Thanks.

-Goalie35


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