Hello,
I have always had formatting problems with pivot tables.
I -of course- always turn autoformat off.
I also created a small macro to set my favorite colors on the pivottables.
Here is the code I am using for that:
I thought, naïvely, that being precise about which pivottable-range I specify, I would ensure stable colors in my pivot table.
And my questions come here.
Why do my colors still change when I refresh the pivottable?
Why do they change even if the data have not changed at all?
Can you write a macro that will freeze once-for-all the format or at least the colors for data and for headers in my pivottables?
I simply want two colors: blue for headers and green for data.
Thanks
I have always had formatting problems with pivot tables.
I -of course- always turn autoformat off.
I also created a small macro to set my favorite colors on the pivottables.
Here is the code I am using for that:
Code:
For Each pt In sh.PivotTables
pt.ColumnRange.Font.ColorIndex = 5
pt.RowRange.Font.ColorIndex = 5
pt.DataLabelRange.Font.ColorIndex = 5
pt.DataBodyRange.Font.ColorIndex = 50
Next pt
I thought, naïvely, that being precise about which pivottable-range I specify, I would ensure stable colors in my pivot table.
And my questions come here.
Why do my colors still change when I refresh the pivottable?
Why do they change even if the data have not changed at all?
Can you write a macro that will freeze once-for-all the format or at least the colors for data and for headers in my pivottables?
I simply want two colors: blue for headers and green for data.
Thanks
Last edited: