Column size will shrink every time when pivot tables are added into sheets

If you are using xl2002 or higher, you can catch the pivottable_change event
and adjust your column widths each time the event fires. If you are using
xl2000 or less your options are very limited as no events fire based on a
pivot table change (you can catch calculate but calculate is so broad that it
rarely works the way you want).

--
HTH...

Jim Thomlinson


"minrufeng" wrote:

>
> This is because that pivot tables are added into the sheet. Does anyone
> know how to stay the column size fixed.
>
> Thanks a lot for your help.
>
>
> --
> minrufeng
> ------------------------------------------------------------------------
> minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
> View this thread: http://www.excelforum.com/showthread...hreadid=400872
>
>

But, how to catch the pivotable_change event and adjust col widths? Thanks a lot for your great help!!

Originally Posted by Jim Thomlinson

If you are using xl2002 or higher, you can catch the pivottable_change event
and adjust your column widths each time the event fires. If you are using
xl2000 or less your options are very limited as no events fire based on a
pivot table change (you can catch calculate but calculate is so broad that it
rarely works the way you want).

--
HTH...

Jim Thomlinson


"minrufeng" wrote:

>
> This is because that pivot tables are added into the sheet. Does anyone
> know how to stay the column size fixed.
>
> Thanks a lot for your help.
>
>
> --
> minrufeng
> ------------------------------------------------------------------------
> minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
> View this thread: http://www.excelforum.com/showthread...hreadid=400872
>
>