Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table limitations | Excel Worksheet Functions | |||
XL2000: Pivot Table Limitations II | Excel Discussion (Misc queries) | |||
Pivot table and subtotals - limitations? | Excel Discussion (Misc queries) | |||
Row limitations on Pivot Table in Excel? | Excel Discussion (Misc queries) | |||
Pivot Table Limitations in 2000 | Excel Worksheet Functions |