Right click anywhere in your pivot table and then select Table Options.
Tick the box Preserve formatting

"Simon" wrote:

I have a pivot table, and I want to format the look of it. I want to make
the text bold in the columns and I also want to make those cells in the
columns to be filled with a particular colour eg grey.

The problem I have is that everytime I refresh the pivot table all changes
that I made to formatting eg. Bold Text or Background Colours get wiped and
the defaults are used.

Is there anyway I can prevent this from happening because it is driving me
nuts....

Thanks in advance.
Simon