question on pivot table

[ohmymy]

Hi,

Is there a limit to the no of columns allowed to be placed in the ro
area?

Excel XP seems to allow more columns to be added as I encountered
limit when using Excel 2000.

Please advise.

Thanks a lot!!

 

[Debra Dalgleish]

These MSKB article outline the limits for Excel 2000 and Excel 2002:

XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?id=211517

XL2002: Limits of PivotTables in Microsoft Excel 2002
http://support.microsoft.com/default.aspx?id=291061