Setting Pivottable RowField Width
 

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

Setting Pivottable RowField Width
 

On 16 Feb, 19:10, mark wrote:
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

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

Setting Pivottable RowField Width
 

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.



"WhytheQ" wrote:

On 16 Feb, 19:10, mark wrote:
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

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