Forum Discussion
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...
I came across this issue whereby my Filter Labels keep changing format upon refresh, while the table itself keeps its format. Managed to find a solution for this:
PivotTable Tools > Design > Click the dropdown for all the different preset formattings > New Pivot Table Styles.
For my case, I just updated the format for 'Report Filter Value' and 'Report Filter Label' cause that's what I was looking for. Hope it helps.
