refresh pivot report

[Guest]

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?

 

[Guest]

Julie

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

This should do the trick.

Roger

 

[Guest]

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