Sorting records in Pivot page field
 

I use VBA to reload data in a Pivot table of an Excel model.
New data occurences are appended to the end of the list in the drop down
list of the pivot page fields. Is there a way to sort the page field list.
The pivot is an Excel-97 object because the my user environment contains
'97/2000/2003 Excel users.

regards,
Erik