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