Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added and deleted. | Excel Discussion (Misc queries) | |||
Extending Field Size in Pivot Tables | New Users to Excel | |||
How to reduce the size of a file that contains pivot tables | Excel Discussion (Misc queries) | |||
How can I shrink a file size w/ a pivot table and many formulas? | Excel Worksheet Functions | |||
How do I unlimit field size in using Excel Pivot Tables? | Excel Discussion (Misc queries) |