Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 05, 03:45 PM
j
 
Posts: n/a
Default 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   Report Post  
Old March 31st 05, 12:14 AM
Debra Dalgleish
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
How do I remove items listed in a pivot table drop down list box Hart165Hour Excel Discussion (Misc queries) 3 March 16th 05 04:19 AM
Pivot Table unable to Include Hidden Items In Subtotals TC319 Charts and Charting in Excel 0 February 24th 05 08:53 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017