| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Data Group and Outline Group" feature Limited to 8 levels
I have found that if you try to "group" a ninth level (via pick-n-click,
macro, or VBA), Excel doesn't complain or give you an error, it just ignors your command and will not group any further. Is there ANY possible way to get around this limitation? I am tracking mass properties for a vehicle's components in a assembly/part or parent/child hierarchy. There are some parts that are MORE THAN 8 levels deep in the assembly. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Data Group and Outline Group" feature Limited to 8 levels
Hi,
A Pivot Table will allow more than 8 levels of grouping. -- Cheers, Shane Devenshire "MarekMG" wrote: I have found that if you try to "group" a ninth level (via pick-n-click, macro, or VBA), Excel doesn't complain or give you an error, it just ignors your command and will not group any further. Is there ANY possible way to get around this limitation? I am tracking mass properties for a vehicle's components in a assembly/part or parent/child hierarchy. There are some parts that are MORE THAN 8 levels deep in the assembly. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Data Group and Outline Group" feature Limited to 8 levels
For my application, I am using the "Group and Outline" feature as a way to
organize my data into a strict, top-down hierarchy. I don't feel that a Pivot Table is the right feature for my particular application. Any ideas for my original question? "ShaneDevenshire" wrote: Hi, A Pivot Table will allow more than 8 levels of grouping. -- Cheers, Shane Devenshire "MarekMG" wrote: I have found that if you try to "group" a ninth level (via pick-n-click, macro, or VBA), Excel doesn't complain or give you an error, it just ignors your command and will not group any further. Is there ANY possible way to get around this limitation? I am tracking mass properties for a vehicle's components in a assembly/part or parent/child hierarchy. There are some parts that are MORE THAN 8 levels deep in the assembly. Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Data Group and Outline Group" feature Limited to 8 levels
Even in version 2007 the grouping feature will not allow more than 8 levels.
So if you must use the Grouping and Outline feature you will be limited to 8 levels. -- Sorry that's the limit and I don't know if there are any plans to enhance this in the next version (2010?), Shane Devenshire "MarekMG" wrote: For my application, I am using the "Group and Outline" feature as a way to organize my data into a strict, top-down hierarchy. I don't feel that a Pivot Table is the right feature for my particular application. Any ideas for my original question? "ShaneDevenshire" wrote: Hi, A Pivot Table will allow more than 8 levels of grouping. -- Cheers, Shane Devenshire "MarekMG" wrote: I have found that if you try to "group" a ninth level (via pick-n-click, macro, or VBA), Excel doesn't complain or give you an error, it just ignors your command and will not group any further. Is there ANY possible way to get around this limitation? I am tracking mass properties for a vehicle's components in a assembly/part or parent/child hierarchy. There are some parts that are MORE THAN 8 levels deep in the assembly. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007: top of screen "File Name [Group]", how to remove [Grou | Excel Discussion (Misc queries) | |||
| How do I sum a occurance of "text" in a group of cells | Excel Discussion (Misc queries) | |||
| I cannot get my Excel sheets to "Group". (Student version 2003) | New Users to Excel | |||
| How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
| "Cannot Group That Selection" in a Pivot Table. | Excel Discussion (Misc queries) | |||
Linear Mode
