PivotTable
26 TopicsPivot 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 dramatically and seemingly randomly. I cannot get the table to save the cell format consistently. Extremely frustrating, and a seemingly known issue with no good fix. Help!!!99KViews3likes25CommentsPasting Pivot Table as Values... losing Borders and formatting
This just started within the last 30 days or so... it appears that when pasting a Pivot Table as values over itself... borders and formatting are now eliminated. Extremely frustrating as I have the need to distribute Pivot Table data to many corporate users, but do not want all of the underlying data to be exposed or shared. Microsoft Office 365 ProPlus, Excel version 1708 (Build 8431.2153 Click-to run) Is there any way to turn this off, or what is the work-around? Tried all kinds of various "pasting formats" and such. Thank You, Brian CatalanoSolved206KViews1like28Comments