Thread: Column size will shrink every time when pivot tables are added into sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
  
Posts: 1,119
Default Column size will shrink every time when pivot tables are added int
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


Reply With QuoteReply With Quote