Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table - max rows allowed in data range
Hi! What is the maximum rows allowed in a data range when using a pivot table?
I have a pivot table that uses a data range. When I have only 4581 records in the data range, the pivot table updates with no problems. But, when entering more than 4581, the pivot table won't update and gives me an error. Am I hitting the max on data rows within my data range or is there a work-around. Thanks!! dmotika |
#2
|
|||
|
|||
The following MSKB articles outline PivotTable limitations for different
versions of Excel: XL2000: Limits of PivotTables in Microsoft Excel 2000 http://support.microsoft.com/default.aspx?id=211517 Limits of PivotTable Reports in Microsoft Excel 2003 http://support.microsoft.com/default.aspx?id=820742 dmotika wrote: Hi! What is the maximum rows allowed in a data range when using a pivot table? I have a pivot table that uses a data range. When I have only 4581 records in the data range, the pivot table updates with no problems. But, when entering more than 4581, the pivot table won't update and gives me an error. Am I hitting the max on data rows within my data range or is there a work-around. Thanks!! dmotika -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Here's one more question on this... I found that the max limit for a "unique
items per field" is 32,500. This pivot table has a comment field in it with lots of text. Could this be what's causing the problem?? "dmotika" wrote: Hi! What is the maximum rows allowed in a data range when using a pivot table? I have a pivot table that uses a data range. When I have only 4581 records in the data range, the pivot table updates with no problems. But, when entering more than 4581, the pivot table won't update and gives me an error. Am I hitting the max on data rows within my data range or is there a work-around. Thanks!! dmotika |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Pivot Tables - Summarising data from 100,000 rows | Excel Discussion (Misc queries) | |||
Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) | |||
Pivot Table Data | Excel Worksheet Functions |