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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested grouping of hierarchical headings during/after import 1
Grouping and Outlining 1
Grouping - limit to number of nested groups? 2
Group and Outline become grayed out unexpectedly 1
Printing only to limited outline levels 1
Iterative Query 1
How do i use subforms and reports with self joins?? 3
Lost my third and fourth level Numbering 1

Back
Top