Help with nested subtotals.

[RobJaxFl]

Excel 2003 SP1
I am using the Excel Data Subtotals function and have noticed a problem when
creating secondary subtotals.

My list is sorted on Producer, ProdType, and Customer. In the primary
subtotal I selected subtotals at each change in Producer (insert totals below
data, page breaks between producers and replace current subtotals). In the
secondary subtotal I selected subtotals at each change in ProdType (insert
totals below data).

The subtotal function inserted the secondary subtotals below the row for the
primary subtotals rather than above that line.

 

[Ken Wright]

Try this link:-

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003

http://support.microsoft.com/default.aspx?scid=kb;en-us;831824

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[jlb7465]

Ken,
New to this discussion. I just tried the fix and it did not work. The
subtotals are still in the wrong postion. The fix was also tried by 2 others
that I know and it did not work for them either. I am running Excel 2003
SP3. Any help would be greatly appreciated.
JLB7465