Setting Pivottable RowField Width

[mark]

Hi.

I have a pivot table in which one row field, "Description", sometimes has a
long value, and therefore the pivot table comes up with it's column set at
168.86 .

A width of about 50 would be good.

This field happens to be in column H, and I could set the column width of
column H to the appropriate amount.

But, I want to do it through the RowField("Description"), somehow... so that
if the pivot table gets changed, and this particular field isn't in column H
any more, I won't need to go back through the code and then tell it what
column "Description" is not in...

Can someone help me set the column width of a specific pivot table row
fields? I've not found it.

Thanks.
Mark

 

[WhytheQ]

Hi.

I have a pivot table in which one row field, "Description", sometimes has a
long value, and therefore the pivot table comes up with it's column set at
168.86 .

A width of about 50 would be good.

This field happens to be in column H, and I could set the column width of
column H to the appropriate amount.

But, I want to do it through the RowField("Description"), somehow... so that
if the pivot table gets changed, and this particular field isn't in columnH
any more, I won't need to go back through the code and then tell it what
column "Description" is not in...

Can someone help me set the column width of a specific pivot table row
fields?  I've not found it.

Thanks.
Mark

could you add another field onto the data that truncates "Description"
to 50 and then use that in the pivot?

 

[mark]

yes, I could do that.

I'd still want the full description in the detail data, so I'd end up with
two columns in the detail... the original, and the left 50.

If there's not a better way, perhaps I'll do that.