Pivot Table cell formats dont stick

  • Thread starter Thread starter RF
  • Start date Start date
R

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
 
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
 
How to retain cell border formatting in an Excel pivot table

This message is attached to quite an old request, but I hope it will be of interest to whoever reads it.



I have found a way to retain the cell border formatting. As you may already have discovered, if you highlight the entire pivot table and use the cell border format that surrounds each cell in a box each time you refresh the pivot table the cell formatting disappears.



To get around this, highlight each row separately and use the border that adds to the bottom of the cell. Now highlight each column separately and use the border that adds to the right side of the cell. You will now have each cell highlighted and it will not change when refreshing the pivot table or using the drop down function of the pivot table.



I am using Excel 2003 - SP3
 
Back
Top