topic A published Nprinting Excel Pivot table shows a different column width than the Designer in Qlik NPrinting

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

julioarriaga — Mon, 20 Sep 2021 16:34:08 GMT

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

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

Frank_S — Mon, 20 Sep 2021 17:21:13 GMT

Which version of Qlik Sense?

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

Lech_Miszkiewicz — Tue, 21 Sep 2021 00:11:58 GMT

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