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...
After making all the edits to your pivot table such as changing the font, font color, adding borders, design etc...
Go to Pivot Table Analyze > On the top left you will find a tab named as "Options" click on it. You will see a pop-up window similar to this
If you observe most likely by default the Auto Fit column widths on Update would be checked, but if you uncheck it and ensure that preserver cell formatting on update is checked then you should be good to go. This solution definitely worked for me.