|
Column size will shrink every time when pivot tables are added into sheets
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 |
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 |
Column size will shrink every time when pivot tables are added into sheets
But, how to catch the pivotable_change event and adjust col widths? Thanks a lot for your great help!! Jim Thomlinson Wrote: 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 -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=400872 |
| All times are GMT +1. The time now is 11:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com