Solved

# Possible number of levels of subtotals in Excel2010

Posted on 2012-09-13
Medium Priority
614 Views
In Excel2003 you are limited to 8 levels of subtotals. What is the limit in Excel2010?
0
Question by:IbDyhr

LVL 35

Assisted Solution

Bembi earned 300 total points
ID: 38398782
Not quite sure, I assume, you mean nested function level?
64...
I have a web site for all limitations, but german....
0

LVL 19

Accepted Solution

Richard Daneke earned 450 total points
ID: 38402039
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.

For 2003 Limits look here:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-P005199291.aspx

For 2010 limits look here:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291#BMworksheetworkbook
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
###### Suggested Courses
Course of the Month13 days, 8 hours left to enroll