Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
LPS LPS is offline
external usenet poster
 
Posts: 108
Default XL2007 - Pivot Table Limitations

I am converting XL2000 Pivot Tables documentation to XL2007 Pivot Tables and
am trying to compare the limitations between the two versions. The on-line
help message is a bit confusing as it does not compare the two versions.
Could someone please confirm or correct the following determination? Also
some of the component names have changed. I wiould like to ensure I am
matching them up correctly between the two versions:

XL2000 XL2007
Total # Pivot Tables = limited by RAM Total # Pivot Tables = limited by
RAM
Page Fields (P.F.) = 256 Report Filters (R.F.) = 256
# of Items in 1 P.F. = 8,000 # of Items in 1 R.F. = 1, 048,
576
Total # P.F. Items = limited by RAM Total # R.F. Items = ?????
# of Row Fields = limited by RAM # of Row Fields = limited by RAM

# of Column Fields = limited by RAM # of Column Fields = limited by RAM

# of Items in 1 Row Fld = 8,000 # of Items in 1 Row Fld = 1, 048,
576
# of Items in 1 Clm Fld = 8,000 # of Items in 1 Clm Fld = 1, 048,
576
Total # Row Items = 2.1 billion Total # Row Items = ?????
Total # Clm Items = 32,768 Total # Clm Items = ?????
Total # Data Fields = 256 Total # Value Fields = 256
Total # Data Items = ????? Total # Value Items = ?????

Any help in determining the maximum numbers for Report Filter Items, and
Row, Column and Value Field Items would be most appreciated.

Thank you.
--
LPS
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default XL2007 - Pivot Table Limitations

EXCEL 2007

Type this:-

EXCEL Specifications And Limits

- into the F1 Help Facility.

If my comments have helped please hit Yes.

Thanks.



"LPS" wrote:

I am converting XL2000 Pivot Tables documentation to XL2007 Pivot Tables and
am trying to compare the limitations between the two versions. The on-line
help message is a bit confusing as it does not compare the two versions.
Could someone please confirm or correct the following determination? Also
some of the component names have changed. I wiould like to ensure I am
matching them up correctly between the two versions:

XL2000 XL2007
Total # Pivot Tables = limited by RAM Total # Pivot Tables = limited by
RAM
Page Fields (P.F.) = 256 Report Filters (R.F.) = 256
# of Items in 1 P.F. = 8,000 # of Items in 1 R.F. = 1, 048,
576
Total # P.F. Items = limited by RAM Total # R.F. Items = ?????
# of Row Fields = limited by RAM # of Row Fields = limited by RAM

# of Column Fields = limited by RAM # of Column Fields = limited by RAM

# of Items in 1 Row Fld = 8,000 # of Items in 1 Row Fld = 1, 048,
576
# of Items in 1 Clm Fld = 8,000 # of Items in 1 Clm Fld = 1, 048,
576
Total # Row Items = 2.1 billion Total # Row Items = ?????
Total # Clm Items = 32,768 Total # Clm Items = ?????
Total # Data Fields = 256 Total # Value Fields = 256
Total # Data Items = ????? Total # Value Items = ?????

Any help in determining the maximum numbers for Report Filter Items, and
Row, Column and Value Field Items would be most appreciated.

Thank you.
--
LPS

  #3   Report Post  
Posted to microsoft.public.excel.misc
LPS LPS is offline
external usenet poster
 
Posts: 108
Default XL2007 - Pivot Table Limitations

Thank you for your reply but that is the Help message I referred to in my
post. It does not answer my questions.

Thanks,
--
LPS


"trip_to_tokyo" wrote:

EXCEL 2007

Type this:-

EXCEL Specifications And Limits

- into the F1 Help Facility.

If my comments have helped please hit Yes.

Thanks.



"LPS" wrote:

I am converting XL2000 Pivot Tables documentation to XL2007 Pivot Tables and
am trying to compare the limitations between the two versions. The on-line
help message is a bit confusing as it does not compare the two versions.
Could someone please confirm or correct the following determination? Also
some of the component names have changed. I wiould like to ensure I am
matching them up correctly between the two versions:

XL2000 XL2007
Total # Pivot Tables = limited by RAM Total # Pivot Tables = limited by
RAM
Page Fields (P.F.) = 256 Report Filters (R.F.) = 256
# of Items in 1 P.F. = 8,000 # of Items in 1 R.F. = 1, 048,
576
Total # P.F. Items = limited by RAM Total # R.F. Items = ?????
# of Row Fields = limited by RAM # of Row Fields = limited by RAM

# of Column Fields = limited by RAM # of Column Fields = limited by RAM

# of Items in 1 Row Fld = 8,000 # of Items in 1 Row Fld = 1, 048,
576
# of Items in 1 Clm Fld = 8,000 # of Items in 1 Clm Fld = 1, 048,
576
Total # Row Items = 2.1 billion Total # Row Items = ?????
Total # Clm Items = 32,768 Total # Clm Items = ?????
Total # Data Fields = 256 Total # Value Fields = 256
Total # Data Items = ????? Total # Value Items = ?????

Any help in determining the maximum numbers for Report Filter Items, and
Row, Column and Value Field Items would be most appreciated.

Thank you.
--
LPS

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 limitations Vagabound_s Excel Worksheet Functions 1 November 26th 08 07:07 PM
XL2000: Pivot Table Limitations II LPS Excel Discussion (Misc queries) 3 October 15th 08 09:43 PM
Pivot table and subtotals - limitations? kimanne Excel Discussion (Misc queries) 5 November 8th 06 11:20 PM
Row limitations on Pivot Table in Excel? Kristina Excel Discussion (Misc queries) 1 July 29th 05 08:22 PM
Pivot Table Limitations in 2000 Pat Excel Worksheet Functions 0 October 28th 04 08:22 PM


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