Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting position of a pivotitem
hello.
I have a pivot table, and need to reset the position of a specific item, in code. I was trying to do that before putting the field into the pivot table grid, so that it doesn't need to recalc afterward. pvT.PivotFields(arColFields(1)).PivotItems("(blank )").Position = 1 works, after the pivot grid is filled with fields, but not before. I was able to select/deselect all of the proper items before populating the pivot grid. But you can't set positions before filling the grid? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom toolbar, setting docked position | Excel Programming | |||
Setting left position works in XL 2k and 2002 but.. | Excel Programming | |||
Set PivotItem using counter | Excel Programming | |||
Setting All Worksheets To The Same Scroll Position | Excel Worksheet Functions | |||
How to add a PivotItem ? | Excel Programming |