LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
LPS LPS is offline
external usenet poster
 
Posts: 108
Default XL2000 Pivot Table Specifications

I am trying to understand the limtiations of XL2000 Pivot Tables but am
getting very confused. This could stem from the way the terminlogy is used
from one source of definitions to another. In the Excel help (Office
Assistant) it says the maximum number of Items in a Pivot Table report is
8,000. Yet, when I read the on-line article
(http://support.microsoft.com/kb/211517/) it says the number of unique Items
per row, column or page field is 8,000. So, is the maximum number of all
row, coumn and page fields 8,000 or is it 8,000 each?

Then the article says, the maximum number of items in all column fields
cannot exceed 32,768. And the maximum number of items in all row fields
cannot exceed 2.1 billion. Whath appened to the 8,000 item limit?

Could someone please clarify this for me?

Any and all help is greatly appreciated.
--
LPS
 
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
Import File With Specifications Ripper Excel Discussion (Misc queries) 8 April 5th 08 01:18 AM
More than 3 specifications for conditional formatting in Excel tpage Excel Discussion (Misc queries) 3 September 18th 06 10:52 PM
How can I automatically rearrange cells to my specifications? Frederique38 Excel Discussion (Misc queries) 3 February 24th 06 08:32 AM
How to increase colums specifications? Consulting guy Setting up and Configuration of Excel 3 November 13th 05 04:21 AM
Where can I find a template for application report specifications. James Excel Discussion (Misc queries) 0 December 10th 04 06:19 AM


All times are GMT +1. The time now is 08:56 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"