Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How many items can a pivot table hold? i.e. a worksheet taps out .
Does anyone know how much data a pivot table will hold???? I can get it to
accept 30,000 items but not 50,000... What are it's constraints? |
#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 j wrote: Does anyone know how much data a pivot table will hold???? I can get it to accept 30,000 items but not 50,000... What are it's constraints? -- 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 | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Pivot Table unable to Include Hidden Items In Subtotals | Charts and Charting in Excel | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |