Couple of questions please

1) Is it possible to sort a row field ( Ascending / descending) by another
field which is not part of the pivot table?

2) For row subtotals, is it possible to change the headings for sub total ?
for eg. the pivot table just adds " sum" after the field . is it possible to
have just " total " and nothing else.

3) is there a way to increase the number of row / column fields in Excel 2000.

current I have 7 fields and its not allowing me to add additional.

Any help appreciated