Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table with multiple sheets in Excel 2000 | Excel Discussion (Misc queries) | |||
excel 2000 pivot table | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 pivot table problem | Excel Worksheet Functions | |||
Pivot table borders | Setting up and Configuration of Excel |