autofit width problem   

Hi,

In an OWC11 pivot table, I have an issue where I have dimensions on columns 
and a single measure whose name is 13 characters long. When I drag that 
measure out then replace it with a measure whose name is 5 characters long 
the grid does not autofit the width.  Instead, it leaves a blank area next to 
the measure.  It actually expands the column more.

Since I have 2 dimensions on the column, if I expand the column then 
collapse it again, it resizes and fits, but only with mouse clicks.  If I 
expand and collapse programmatically, nothing changes.

Is there a work-around or any way in vbscript to trigger an auto resize or 
autofit method on a fieldset, fields, or totals?

Thanks,

--Joe

date: Wed, 25 Jun 2008 13:45:00 -0700   author:   Joe Sampino