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

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

Yeah I've tried that. As soon as I refresh the table all my formatting is
replaced.
Any other ideas?

"Dennis" wrote:

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

The problem was with the type of pivot table format I was using, I changed
the type of pivot table format and selected one which was fairly plain, I was
then able to make the necessary format changes and the pivot retained the
changed I made even after refreshing.

"Simon" wrote:

Yeah I've tried that. As soon as I refresh the table all my formatting is
replaced.
Any other ideas?

"Dennis" wrote:

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