Forum Discussion

Andrew Knott's avatar
Andrew Knott
Copper Contributor
May 02, 2019

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...
excel
office 365
PivotTable
Andrew Knott's avatar
Andrew Knott
Copper Contributor
May 02, 2019

getbest The formatting issue is related to borders and centering. This clip is from the table. The data is below the grey headers.

LuizCL's avatar
LuizCL
Copper Contributor
Jan 24, 2020
Exactly same issue (Office 365 Personal)
  • User1400's avatar
    User1400
    Copper Contributor
    Jan 24, 2020

    LuizCL 

     

    Yes, pivot table cells don't preserve cell formatting on update.

Resources