refresh pivot report
 

Every time I refresh my pivot table I lose formatting that I have to re-do
every time, specifically column widths, cell borders and cell formatting such
as bold and wrapped. I also lose this formatting when I use my page fields
drop down box to look at different groups of data.

Is there anything I can do to retain my formatting in these situations?
--
Julie

refresh pivot report
 

Julie

If you go into the Pivot table options you can de-select the box "Auto
Format Table".

This should do the trick.

Roger

"Julie" wrote:

Every time I refresh my pivot table I lose formatting that I have to re-do
every time, specifically column widths, cell borders and cell formatting such
as bold and wrapped. I also lose this formatting when I use my page fields
drop down box to look at different groups of data.

Is there anything I can do to retain my formatting in these situations?
--
Julie

refresh pivot report
 

Check the preserve formatting check box under pivot table options and it can
solve the lot of the problems you have referred to.
"Julie" wrote:

Every time I refresh my pivot table I lose formatting that I have to re-do
every time, specifically column widths, cell borders and cell formatting such
as bold and wrapped. I also lose this formatting when I use my page fields
drop down box to look at different groups of data.

Is there anything I can do to retain my formatting in these situations?
--
Julie