"Data > Group and Outline > Group" feature Limited to 8 levels

M

MarekMG

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?
 
M

MarekMG

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?
 
S

ShaneDevenshire

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.
 
Top