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?