I have Excel2000 and would like to be able to sort the data elements in the
Row section of the pivot table in the order I choose. For example, if I have
3 elements such as Apple, Orange, Cranberry and want them to show in the
pivot in this order I have to name them in the dataset as A. Apple, B.
Orange, C. Cranberry and sort them ascending. Is there a way to do this
without having to stick the A, B, C in front of the data item?

Thx