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...
Hi Andrew,
How about cleaning up pivot source data and try again. Pivot usually change formats based on source data. If pivot forces format, actually that is the best way to go.
Regards,
J
Wrong. 100% wrong.
I have the same issue. So do thousands of other people. My source data is formatted the way I want it. My query properties are the way I want them. I have "Preserve cell formatting on update" selected. It still changes back every time I refresh data. There is no way. Another in the infinite list of Excel failures.
You may refer to the solution in my reply on Jul 30 2022.
"Preserve cell formatting on update" alone is not working. I also wonder why Microsoft technical team can't find a solution.
