Forum Discussion

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...

Copper Contributor

Jan 23, 2020

Andrew Knott

This is an ongoing issue with Excel for some years now, nothing that Microsoft suggest works and they are not doing anything to fix the problem.

pnoll

Copper Contributor

Dec 31, 2020

User1400

This has been an issue for years. I can only assume there are not enough power users who are pivot table enthusiasts for them to care. It drives me crazy and will probably be the reason i stop using excel. I am already experimenting with Tableau to see how can start to move away.