PowerPivot Pivot Chart Formatting

[AndrewKent]

Hi there,

I'm aware that there is an issue in Excel whereby using Slicers to filter your pivot table/chart will cause the formatting to reset to the default. I am experiencing this issue however I am noticing some odd behaviour.

My slicers control pivot charts across multiple tabs. If I open each tab and scroll up/down (basically so I have viewed each chart) then when I use my slicers the formatting is maintained. If I don't do this, the formatting resets to the default.

What would be considered a good workaround for maintaining formatting on Pivot Charts?

Andy