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
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.
- Andrew,
Which version of Excel are you using. I am using Excel 2013 and it's pivot stays same even after regular refresh or slices.
J
getbest The formatting issue is related to borders and centering. This clip is from the table. The data is below the grey headers.
- Exactly same issue (Office 365 Personal)
