Pivot Limitations

[Lorena]

Does anyone know the row limitations to a Pivot table? Current Pivot table includes approximately 6000 rows. Trying to add additional rows but receiving a "too many rows to update" error

 

[Frank Kabel]

Does anyone know the row limitations to a Pivot table? Current Pivot
table includes approximately 6000 rows. Trying to add additional
rows but receiving a "too many rows to update" error.

Hi
search the Excel help file for 'Specification' and choose 'pivot
table'. e.g. maximum of data entries: 256.

Frank

 

[Hiran de Silva]

Lorena,

The Bible on this is ...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;291061
XL2002: Limits of PivotTables in Microsoft Excel 2002

http://support.microsoft.com/default.aspx?scid=kb;EN-US;211517
XL2000: Limits of PivotTables in Microsoft Excel 2000

http://support.microsoft.com/default.aspx?scid=kb;EN-US;157486
XL97: Limits of PivotTables in Microsoft Excel 97

http://support.microsoft.com/default.aspx?scid=kb;EN-US;197331
Excel for Macintosh: Limits of Pivot Tables

Hiran