| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Borders in Pivot Tables
Is there any way to not lose border formatting after refreshing a Pivot
Table? I can keep the outside borders but the linside lines awlays have to be placed back. Thank you. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Borders in Pivot Tables
This is a known bug that required vba code to re-apply formatting.
XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy DeeJay wrote: Is there any way to not lose border formatting after refreshing a Pivot Table? I can keep the outside borders but the linside lines awlays have to be placed back. Thank you. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronising pivot tables | Excel Discussion (Misc queries) | |||
| Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
| #REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
| Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Linear Mode
