A published Nprinting Excel Pivot table shows a different column width than the Designer

[julioarriaga]

Hi,

Whenever I publish a pivot table on Excel, the column widths are changed from what was configured on the Designer?

Is there a way to control this?

I am using the Preview button to visualize the published report.

I appreciate, as always, the enormous help. 

Column Widths on the Designer

Column Widths in Published Excel view

[Frank_S]

Which version of Qlik Sense?

[Lech_Miszkiewicz · Accepted solution]

In my opinion this is Excel Pivot Table setting which you have to set in NP designer Excel Template --> Your Pivot table--> Pivot Table Options --> "Autofit column widths on update" - Untick!

I tested it and it works for me.

cheers