Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kristina
 
Posts: n/a
Default Row limitations on Pivot Table in Excel?

Does anyone know what the row limitation in an Excel Pivot table is? I'm
working with Excel 2000 and I'm getting a message stating that I'm exceeding
the amount allowed. Also, does anyone know if this is a limitation in the
newest version of the product? I'm trying to determine if it's worth the
upgrade.
-Any help is greatly appreciated!
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

Some limits have been increased for later versions. The following MSKB
articles outline PivotTable limitations for different versions of Excel:

Limits of PivotTables in Excel
http://support.microsoft.com/default.aspx?id=211517

Description of the limits of PivotTable reports in Excel
http://support.microsoft.com/default.aspx?id=820742

Kristina wrote:
Does anyone know what the row limitation in an Excel Pivot table is? I'm
working with Excel 2000 and I'm getting a message stating that I'm exceeding
the amount allowed. Also, does anyone know if this is a limitation in the
newest version of the product? I'm trying to determine if it's worth the
upgrade.
-Any help is greatly appreciated!



--
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
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Table Security in Excel JBankson Excel Discussion (Misc queries) 0 February 2nd 05 12:01 AM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 07:27 AM.

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

About Us

"It's about Microsoft Excel"