Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Formats not maintained?
I've created 5 Pivot Tables using one database. I've setup column widths and
font formats. I've unchecked the Autofit Col Widths and checked the Preserve Formatting boxes PT Options, Layout & Format. On all 5 of the PT's, when I edit a record or add a new record, and then Refresh the PT, the formatting for those edited or new records is lost (alignment, boldness, etc.). All unedited records seem to maintain their format. On 1 of the 5 PT's, an entire column loses it's formatting even if I don't edit or add anything and just Refresh the PT. What gives? The PT's treatment of formats seems random at best. Are there some other boxesI should be checking and/or unchecking? Thanks .... Rick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Formats not maintained?
Sadly, no. It is a known issue by Microsoft that PivotTables do not retain
their formats when you refresh. Their recommended solution is to record a macro of you setting the desired formats, and then either running the macro yourself after a refresh, or set it up automatically (using worksheet event in VBA). If you decide to go with the automatic approach, I'd recommend searching this group for Worksheet_Change events, or a Google search about such things. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jeeslawees" wrote: I've created 5 Pivot Tables using one database. I've setup column widths and font formats. I've unchecked the Autofit Col Widths and checked the Preserve Formatting boxes PT Options, Layout & Format. On all 5 of the PT's, when I edit a record or add a new record, and then Refresh the PT, the formatting for those edited or new records is lost (alignment, boldness, etc.). All unedited records seem to maintain their format. On 1 of the 5 PT's, an entire column loses it's formatting even if I don't edit or add anything and just Refresh the PT. What gives? The PT's treatment of formats seems random at best. Are there some other boxesI should be checking and/or unchecking? Thanks .... Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Formats not maintained?
Thanks Luke. I may look into it. Since I dn't update this database too
often and therefore don't Refresh the PT's too often, I may just manually "fix up the mess" each time. Such is life in Microsoft world. "Luke M" wrote: Sadly, no. It is a known issue by Microsoft that PivotTables do not retain their formats when you refresh. Their recommended solution is to record a macro of you setting the desired formats, and then either running the macro yourself after a refresh, or set it up automatically (using worksheet event in VBA). If you decide to go with the automatic approach, I'd recommend searching this group for Worksheet_Change events, or a Google search about such things. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jeeslawees" wrote: I've created 5 Pivot Tables using one database. I've setup column widths and font formats. I've unchecked the Autofit Col Widths and checked the Preserve Formatting boxes PT Options, Layout & Format. On all 5 of the PT's, when I edit a record or add a new record, and then Refresh the PT, the formatting for those edited or new records is lost (alignment, boldness, etc.). All unedited records seem to maintain their format. On 1 of the 5 PT's, an entire column loses it's formatting even if I don't edit or add anything and just Refresh the PT. What gives? The PT's treatment of formats seems random at best. Are there some other boxesI should be checking and/or unchecking? Thanks .... Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Formats | Excel Discussion (Misc queries) | |||
Hot To Copy Pivot Table formats | Excel Worksheet Functions | |||
pivot table formats | Excel Discussion (Misc queries) | |||
Pivot table formats | Excel Discussion (Misc queries) | |||
Basic: Pivot Table formats | Excel Discussion (Misc queries) |