Hi,
Pivot is a report in tabular format, based on a TABLE.
The TABLE has some columns of download data, and further columns calculating sums and logical messages.
I extract the salient rows from the table for this stakeholder, using a tabular pivot format. There are around 15 "Row" columns in the Pivot, including some Fields with text items, that I have formatted to a certain width. Then around 15 "Values" columns
I have unticked the box in PIVOTTABLE OPTIONS (i.e Unticked "Autofit column widths on update"), whilst retaining the tick in the "Preserve cell formatting on update" box. But to no avail.
I cannot see a way to get the COLUMN WIDTH to STICK via Pivot Conditional formatting ascribable to each pivot field (only has Number, Font, Border, Field) - such that formatting for a pivot field "ports", even as field order is changed.
So when I bring a new field in to the pivot, or change the order, the pivot field width does not "follow" that field.
Is there a solution to this?
Thanks.
Pivot is a report in tabular format, based on a TABLE.
The TABLE has some columns of download data, and further columns calculating sums and logical messages.
I extract the salient rows from the table for this stakeholder, using a tabular pivot format. There are around 15 "Row" columns in the Pivot, including some Fields with text items, that I have formatted to a certain width. Then around 15 "Values" columns
I have unticked the box in PIVOTTABLE OPTIONS (i.e Unticked "Autofit column widths on update"), whilst retaining the tick in the "Preserve cell formatting on update" box. But to no avail.
I cannot see a way to get the COLUMN WIDTH to STICK via Pivot Conditional formatting ascribable to each pivot field (only has Number, Font, Border, Field) - such that formatting for a pivot field "ports", even as field order is changed.
So when I bring a new field in to the pivot, or change the order, the pivot field width does not "follow" that field.
Is there a solution to this?
Thanks.
