There is a function in Excel called Subtotals (accessible via the Data menu)
which is supposed to group together and subtotal rows of data. The function
can be used multiple times to provide nested subtotals to calculate, in this
case Mobile phone bills in a large company.

When we upgraded the machine from Office 2000 to Excel 2003, there appeared
to be a problem with this function when we tried to create these nested
subtotals. If we use the term €˜Directorate for the first layer of
sub-totals, and the term €˜Department for the second layer of sub-totals,
then the sub-total for the last Department in a particular Directorate
appeared below the sub-total for the Directorate as a whole. This means that
the phone bill for the last department in each Directorate was listed against
the next Directorate down the list. This problem appeared with or without
blanks in the Department field.

We tested this in 3 different environments; Excel 2003 on Windows XP, Excel
2000 on Windows XP, and Excel 2000 on Windows 2000. Problem only appeared in
Excel 2003 and Windows XP environment, so the common denominator appeared to
be Excel 2003?


--
Regards
Dave