Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table Limits?
I have a pivot table that was created by another user. It is keyed off a
generator field that has a three character identifier in it. I should be picking up six of these generators but I am only picking up five. When I change one of the records at the top to the missing generator, I pick that record up but if I move one of the records to the bottom, I lose that record. Is there a limitation on how many rows a pivot table can use or is it limited when it's created? -- RLR |
#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 Robbie wrote: I have a pivot table that was created by another user. It is keyed off a generator field that has a three character identifier in it. I should be picking up six of these generators but I am only picking up five. When I change one of the records at the top to the missing generator, I pick that record up but if I move one of the records to the bottom, I lose that record. Is there a limitation on how many rows a pivot table can use or is it limited when it's created? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Pivot table limits | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |