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