Pivot Table: Preserve cell formatting on update not working

Hi,

I find you have to make sure you select the entire Pivot column using Enable Selection before applying the formatting.

This is enabled via Pivot Table Analyse/Actions/Select. It was already enabled when I opened your file. So then you need to hover the cursor just under the desired column header until you get the little black down-arrow, after which you can left-click to select the entire Pivot column and then apply your formatting. Highlighting the equivalent worksheet cells does not seem to work, as you've probably already tried.

Regards

This old 2009 thread might offer some help although it seems that there is no automatic way that a refresh will do the trick, you will need to add a macro instruction to reformat. I generally use the Sheet Activate event on the sheet that holds the PT but you could equally add the code to your Workbook RefreshAll

Please Login or Register  to view this content.

[/CODE]

https://www.excelforum.com/excel-for...alignment.html