Possible number of levels of subtotals in Excel2010

Posted on 2012-09-13
Last Modified: 2012-09-16
In Excel2003 you are limited to 8 levels of subtotals. What is the limit in Excel2010?
Question by:IbDyhr
    LVL 35

    Assisted Solution

    Not quite sure, I assume, you mean nested function level?
    I have a web site for all limitations, but german....
    LVL 18

    Accepted Solution

    Technically, Microsoft went from 7 nested to 64.  7 nested is a total of 8 subtotals.

    So, from Microsoft's msdn, levels have increased to 64.
      See link:

    For 2003 Limits look here:

    For 2010 limits look here:

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now