software

I just updated a group of users from Excel XP (2002) to Excel 2003, current
service patch. They are running into an issue with Subtotals:

Multilevel subtotals are in the wrong position.

Example. I sort a worksheet by three levels using Datagt;Sort, then subtotal
three times using Datagt;Subtotal, the same fields used to sort, the sum
function and do not have the Replace Current Subtotals box checked. On the
previous version of Excel the subtotals were then nested in the correct
order, on the new version some are and some aren’t, the ones that aren’t have
their first total in the second level.Thanx

Guy M

See

support.microsoft.com/kb/831824/en-us
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;gmassonquot; gt; wrote in message
...
gt; I just updated a group of users from Excel XP (2002) to Excel 2003,
current
gt; service patch. They are running into an issue with Subtotals:
gt;
gt; Multilevel subtotals are in the wrong position.
gt;
gt; Example. I sort a worksheet by three levels using Datagt;Sort, then
subtotal
gt; three times using Datagt;Subtotal, the same fields used to sort, the sum
gt; function and do not have the Replace Current Subtotals box checked. On the
gt; previous version of Excel the subtotals were then nested in the correct
gt; order, on the new version some are and some aren't, the ones that aren't
have
gt; their first total in the second level.
gt;
gt;
gt; Thanx
gt;
gt; Guy M