G
Guest
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
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