Pivot Table cell formats dont stick

[RF]

I'm trying to set up a pivot table with the cell borders
in black all the way around, and I want them to stay that
way when I choose values from a field in the PageField
section. The problem is that when I select an entry in
the page field, all the cell formats (not the number
format) goes away for some of the cells.

I have set the format for the whole pivot when nothing is
selected in any page field, I have unchecked
the "AutoFormat" in table options, preserve formatting is
checked though.

I have tried every combination I know of to keep cell
border formats, but nothing works.

This is Excel 2002, SP-2.

Thanks,
RF

 

[Debra Dalgleish]

Some pivot table formatting just won't stick. You could record a macro
as you select the pivot table, and apply the border formatting.

Then, use the PivotTableUpdate event to run the macro, e.g.:

Private Sub Worksheet_PivotTableUpdate _
(ByVal Target As PivotTable)
FormatPivotTable
End Sub