Forum Discussion
Andrew Knott
May 02, 2019Copper Contributor
Pivot Table formatting after refresh
I have a pivot table set up, and have selected "Preserve cell formatting on update" in PivotTable Option. However, when I select a different slicer or refresh the data, the cell formats change dramat...
Ericxsim
Jul 30, 2022Copper Contributor
This method is working for me. To move your mouse over column header in pivot table until it changes to black arrow, then click column header to select whole column. Once the whole column is selected, you may proceed to format cell. This method is also working perfectly even you use conditional formatting. Please take note that in some cases, you may need to select more than one column for this method to work.
- Luis_AndresOct 04, 2022Copper Contributor
Ericxsim yes this solved the problem... awesome