Redundant Subtotal Level

[Guest]

I'm working on fixing a legacy report to account for the subtotaling issues
that came up in Excel 03. One result of the "fix" is that I now have one
level of subtotaling that doesn't do anything (i.e. click the 1 box and I see
the grand total line, click the 2 box and nothing happens, click the 3 box
and I get my first expansion...) So, is there any way to easily remove the 2
level in this report?
Thanks

 

[Tom Ogilvy]

If you are referring to

http://support.microsoft.com/kb/831824
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003

then I believe there has been a fix released for that.