LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Pivot table row fields limit vs. number of rows in use for Excel 2

I'm confused on the definitions of row field "items" limits vs. number of
rows in use, and "items" in a field and report.

Help bulletin 264626 states there is a limit of "8,000 items in a PivotTable
report".

HB 211517 states "There is a limit of 8,000 unique items per row field,
column field, or page field." And "The prduct of the number of items in all
row fields in a PivotTable cannot exceed ...approx. 2.1 billiion items."

Here is my problem. Existing PT report suddenly started showing error
message on Excel 2000 or earlier versions when trying to use drop down sort
box from Page field. Says "Unable to make change. Too many row field
items...drag one of the row fields to Page field location or delete from PT."
When I do either of these I can sort the drop down box again. Newer Excel
versions have no problem sorting, I'm guessing since they can handle up to
32,500 items in a field. I am trying to understand what exactly is the
limiting factor for the older versions. One expert is telling me that the
total number of report rows has a 2800 line limit but I can't find that
anywhere in the Help database. Year end report for last year was just under
2800 total rows and works fine for all versions. Currently trying to
consolidate data to get down to 2800 rows hoping report will again work on
older versions. Any insite would be appreciated.
 
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
Pivot Table Repeats Names in multiple rows Riccardo Excel Discussion (Misc queries) 3 October 3rd 06 09:53 PM
Select all subtotal rows on Pivot Table Marcotte A Excel Worksheet Functions 2 February 23rd 06 06:10 PM
Derived Columns in Pivot Table sa02000 Excel Discussion (Misc queries) 1 February 8th 06 07:18 PM
pivot table error (25000 rows!!) Craig_Richards Excel Discussion (Misc queries) 1 November 13th 05 06:52 PM


All times are GMT +1. The time now is 09:35 PM.

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

About Us

"It's about Microsoft Excel"