Max Number Fields/Columns In Pivot Table
 

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

Max Number Fields/Columns In Pivot Table
 

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

Max Number Fields/Columns In Pivot Table
 

Thanks everyone but I found the info I needed.

John


"John Calder" wrote:

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