refresh pivot report

J

Julie

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?
 
R

RogerN

Julie

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

This should do the trick.

Roger
 
S

Suresh

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