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...
Here is what I did
I cleared the pivot format from pivot design
Next, selected the row/cells for which i wanted formatting, right client, and select format cells
Formatted the Font, cell color and Number formats
Check on Pivot table Options> Layout a& Format> Checked True on the "Preserve Cell on Update " Option
Formatting didnt change after refresh and was retained
Hi I am also facing the same issue and I followed the exact steps as you mentioned but I lose the formatting I saved once I refresh the Pivot table. Can you please suggest?
