Pivot table # of fields

[Dino]

Is there a limit to the number of fields (including calculated field) that I
can put into the data section on a pivot table?

I have fields of Current, Over30, Over60, Over90, Over120 and Total. I'm
trying to add calculated fields to calc the % of Total for each the Current,
Over30, Over60 etc. All works fine until I get to the Over120%. The formula
is fine but it doesn't show up on the pivot table. The only way I can get it
to show is if I manually delete one of the other calculated fields. Figured
it must be a limit - if so, is there any other way around it?

 

[Debra Dalgleish]

The following MSKB articles outline PivotTable limitations for different
versions of Excel:

Limits of PivotTables in Excel (Excel 97 - 2000)
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel (2002-2003)
http://support.microsoft.com/default.aspx?id=820742

 

[Dino]

Thank you Debra. It's obviously something else making this field not show
up. I'll try again.

 

[Debra Dalgleish]

What version of Excel are you using? Does it look like you haven't
surpassed any of the limits?