autofit width problem

J

Joe Sampino

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table AutoFit 1
Create form with checkbox les that expand and collapse sections of the form? 0
autofit with wrap 1
Row auto height 0
VBA - (re-) Set a Table Style 2
Currency autofit 5
Table Preferred width is changed when pasting 1
Two columns followed by single page-width column on same page 0

Top