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




"Debra Dalgleish" wrote in message
...
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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html