|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 30th, 2005, 03:45 PM
|
|||
|
|||
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
March 31st, 2005, 12:14 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Tables, Help? | Adam | General Discussion | 6 | March 24th, 2005 02:35 PM |
| Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Excel Pivot Table - Calculated Items Problem | BobsySpud | General Discussion | 1 | August 2nd, 2004 08:47 PM |
| Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |
Linear Mode
