Hi everyone!

I'm using EXCEL 97 and have the foll code:

Dim Thisitem as Pivotitem
Dim Pvtitem as String
With MypivotTable
For Thisitem in .pivotfields("FY").pivotitems

If Thisitem.Recordcount > 0 then
Pvtitem = Thisitem.name
Exitfor

Endif

Next
End with

The pivottable is sorted. Whenever the last item was < current item it is still remembered even when not showing up in the table. Is there a way to flush all the old items from memory?

Appreciate your help,

Jamuna