Sorry, it appears I can add another field, the problems seems to be that I
cant add another calculated field, is there a restriction on the number of
calculated fields I can add?

"John Calder" wrote:

Hi

I run Excel 2000

I would like to know the maximum number of fields/colums that a pivot table
will hold.

I have a pivot table with 10 fields (2 of these are calculated) and it does
not seem to allow me to add any more?

Thanks in advance

John