Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a problem with the ListBox Page Fields in a pivotTable. This Fields in ListBox aren't updated. The code is: Set pvtTable = Worksheets("Ordini").Range("A9").PivotTable If pvtTable.RefreshTable = False Then MsgBox "Not Updated Pivot Table" pvtTable.PivotCache.OptimizeCache = True pvtTable.Update Example: Fields : A | B | C Data: 1 xx xx " 2 xx xx " 3 xx xx In the listbox, when i Click the arrow near the Field "A" there are this data: All, 1 , 2 , 3 with the flag. now i delete the row 2 from the data,Update the PivotTable and i click the field "A" and i find the same data:All, 1 , 2 , 3 with the flag. Why ? The Pivot table remember also the data that aren't or not update. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2003 PIvotTable Calculated Fields | Excel Discussion (Misc queries) | |||
Pivottable Sum of fields. | Excel Discussion (Misc queries) | |||
pivottable calculated fields | Excel Discussion (Misc queries) | |||
pivottable page fields | Excel Programming | |||
Sorting Page fields in PivotTable | Excel Programming |