Forum Discussion
Pivot Table formatting after refresh
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.
getbest So, the data is a table that is formatted as a table. I don't change the formatting between refreshes. But on pivot refresh, the pivot formats to "random" formatting. Sometimes, the formats I set are kept, sometimes not. I can't figure out a pattern for the formats it keeps.
Andrew Knott I believe you can specify cell number formatting by value field setting.
If you load a file. I may be able to do it for you.
J
- Sorry--can't upload the whole file. Screenshot below.
