Format PivotTable

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have a standard pivot table in excel 2003. I format the table and some of
the cells with borders, colors, etc. When I refresh the table, the colors
remain but the borders for the cells are removed.

I've tried changing the Preserve Formatting and the Autoformat Table and I
still get the same results...Is there a way to keep the format of the table
while refreshing it?

thanks in advance for your help
 
Hi PeterM,

Well formatting and pivots are not good friends until excel 2007, however
you could try what I did.

Presuming you have a pivot table not formatted as yet and without
specifically ticked boxes in a dropdown list (I mean it should be ticked
"show all") try the following:

Let's say your pivot table is between cells A2:H26 (yest there will be some
blanks probably especially at the top where the page field is but don't
worry).
Now go to cell L2 and type: =A2 and hit enter.
Now drag and copy this until S2 and drop it. Having done so, drag and copy
these 8 cells down until you reach row 26 (I always copy further incase my
pivot extends because of new data).
Now you have dynamic values and "0" where blank cells in a pivot are. You
can format it and create a dynamic copy in another workbook. I know there are
some cons but this has worked for me on many ocassions.

Sorry, for the dummy like description but I wanted to be clear enough. Hope
this helps you somehow.
Regards,
Piotr
 
Back
Top