problems update pivot

Hi guys,

I'm playing with this easy pivot but when I'm changing formatting (for istance size of columns exc.) and I go for an update of the values after modifying the original pivot sourcing then all formatting (size cells exc.) get back to the original sample size which is very frustrating when having very large column text

Anyone knows how to eventually get a record (run a macro) to the original columns size I had before

Hi,

Go into Pivot Table options and deselect "Autofit column widths on update".

Cheers pivot table options.jpg

tooooooooooooooooooooooooooooooop