pivoitems displaying data from source sheet instead of pivot table!

i was originally tryong to filter my pivot table.just to test my data i wrote the following code to undertand it better

For Each fld In PTABLE.PivotFields
For Each PVITEM In fld.PivotItems
MsgBox (fld.name & " " & fld.Value)
MsgBox (" " & PVITEM.Value)
Next PVITEM
Next fld

pivot table has page fields so it dosnt have all data from original sheet....(created pivot table on new sheet)
but above could shows all items from source sheet

using excel 2007
have used pivot wizard method n not pivot cacche