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 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.
Andrew Knott Curious if you ever found a solution for this?
Am struggling with it every day and would love to find a fix!
Nicole_eatenlightened Ive seen several Layouts that Link to the bad formatted cells and clean that up in another sheet ... crzy stuff with MS everywhere - I thought 2021 MS 365 - must be awesome ! lots of quirky stuff still, pivot queries cant figure out what to do with % values, delete last digit, Queries become orphaned , errors , really frustrating.
In 1978 I spent 12 hours a day in the computer lab, nothing has changed !
