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
Maybe this will help
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
2003
support.microsoft.com/default.aspx?kbid=831824
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
quot;David Ilesquot; gt; wrote in message
...
gt; There is a function in Excel called Subtotals (accessible via the Data
menu)
gt; which is supposed to group together and subtotal rows of data. The
function
gt; can be used multiple times to provide nested subtotals to calculate, in
this
gt; case Mobile phone bills in a large company.
gt;
gt; When we upgraded the machine from Office 2000 to Excel 2003, there
appeared
gt; to be a problem with this function when we tried to create these nested
gt; subtotals. If we use the term 'Directorate' for the first layer of
gt; sub-totals, and the term 'Department' for the second layer of sub-totals,
gt; then the sub-total for the last Department in a particular Directorate
gt; appeared below the sub-total for the Directorate as a whole. This means
that
gt; the phone bill for the last department in each Directorate was listed
against
gt; the next Directorate down the list. This problem appeared with or without
gt; blanks in the Department field.
gt;
gt; We tested this in 3 different environments; Excel 2003 on Windows XP,
Excel
gt; 2000 on Windows XP, and Excel 2000 on Windows 2000. Problem only appeared
in
gt; Excel 2003 and Windows XP environment, so the common denominator appeared
to
gt; be Excel 2003?
gt;
gt;
gt; --
gt; Regards
gt; Dave
Thanks for that but the office 2003 is running the sp1 already
--
Regards
Davequot;Bob Phillipsquot; wrote:
gt; Maybe this will help
gt;
gt; Multilevel subtotals are in the wrong position in Excel 2002 and in Excel
gt; 2003
gt; support.microsoft.com/default.aspx?kbid=831824
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;David Ilesquot; gt; wrote in message
gt; ...
gt; gt; There is a function in Excel called Subtotals (accessible via the Data
gt; menu)
gt; gt; which is supposed to group together and subtotal rows of data. The
gt; function
gt; gt; can be used multiple times to provide nested subtotals to calculate, in
gt; this
gt; gt; case Mobile phone bills in a large company.
gt; gt;
gt; gt; When we upgraded the machine from Office 2000 to Excel 2003, there
gt; appeared
gt; gt; to be a problem with this function when we tried to create these nested
gt; gt; subtotals. If we use the term 'Directorate' for the first layer of
gt; gt; sub-totals, and the term 'Department' for the second layer of sub-totals,
gt; gt; then the sub-total for the last Department in a particular Directorate
gt; gt; appeared below the sub-total for the Directorate as a whole. This means
gt; that
gt; gt; the phone bill for the last department in each Directorate was listed
gt; against
gt; gt; the next Directorate down the list. This problem appeared with or without
gt; gt; blanks in the Department field.
gt; gt;
gt; gt; We tested this in 3 different environments; Excel 2003 on Windows XP,
gt; Excel
gt; gt; 2000 on Windows XP, and Excel 2000 on Windows 2000. Problem only appeared
gt; in
gt; gt; Excel 2003 and Windows XP environment, so the common denominator appeared
gt; to
gt; gt; be Excel 2003?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Regards
gt; gt; Dave
gt;
gt;
gt;
- May 16 Wed 2007 20:37
Subtotal
close
全站熱搜
留言列表
發表留言