Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable-Fields Page
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable-Fields Page
My understanding is this is by design. Since at least at some point, 2 was
a valid value, it is retained in the drop down. when you select it, no data is displayed, but this does not meant that 2 is not a possible legal value. Debra Dalgleish has code for removing the items: http://www.contextures.com/xlPivot04.html -- Regards, Tom Ogilvy "Andrea" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |