Excel 2000 PIvot Table Borders
 

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.

--
LPS

Excel 2000 PIvot Table Borders
 

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.

LPS wrote:
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
Contextures
http://www.contextures.com/tiptech.html