Excel 2000 PIvot Table Borders

[LPS]

When I add borders to a Pivot Table, and then refresh the data, the borders
disapper. Is there anyway to prevent that from happening? The "preserve
formatting" checkbox under Options is active.

 

[Debra Dalgleish]

There are a few pivot table format settings that don't seem to stick,
and inside borders are among those.

You could record a macro as you apply the border formatting, then run
that macro as required.