Pivot Limitations

G

Guest

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
 
F

Frank Kabel

Lorena said:
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.
Click to expand...

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

Frank
 
H

Hiran de Silva

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table filter list - listing irrelevant subcategorys 1
Pivot ungrouping on refresh? 3
Adding to an existing Pivot Table 7
Pivot Table - 3
XL2007 - Pivot Table Limitations 2
Limited Pivot Tbl Row and Column Fields 4
Excel VBA For excel 0

Top