User Profile
nsampath
Copper Contributor
Joined Jul 06, 2023
User Widgets
Recent Discussions
Re: Pivot Table formatting after refresh
After making all the edits to your pivot table such as changing the font, font color, adding borders, design etc... Go to Pivot Table Analyze > On the top left you will find a tab named as "Options" click on it. You will see a pop-up window similar to this If you observe most likely by default the Auto Fit column widths on Update would be checked, but if you uncheck it and ensure that preserver cell formatting on update is checked then you should be good to go. This solution definitely worked for me.
