View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default 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