| 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) | |||
Linear Mode
