Excel 2000 PIvot Table Borders

L

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.
 
D

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.
 
Top