| 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 | |||
Linear Mode
