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...
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.
Jgetbest I'm on the latest O365 version (1903 build 11425.20204). The updating seems random--i.e. some of the formats remain, some don't. Would be nice to be able to understand what the issue is.
getbest The formatting issue is related to borders and centering. This clip is from the table. The data is below the grey headers.
