Format PivotTable

[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

 

[Piotr (Peter)]

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