Subtotal - Directorate
 

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

Subtotal - Directorate
 

Maybe this will help

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003
http://support.microsoft.com/default.aspx?kbid=831824

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"David Iles" wrote in message
...
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

Subtotal - Directorate
 

Thanks for that but the office 2003 is running the sp1 already
--
Regards
Dave


"Bob Phillips" wrote:

Maybe this will help

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003
http://support.microsoft.com/default.aspx?kbid=831824

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"David Iles" wrote in message
...
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