i am using office 2002 at work and seem to get a problem every time i use
subtotals,
i use level 2 of the subtotals (up to here it is ok ) and then place the
values in descending order. each time i do this "Grand Total" appears on the
first line and gives an error.can any one suggest a reason for this.

at home i use excel 2003 and no problems
--
alexanderd

Sounds like:

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824


alexanderd wrote:

i am using office 2002 at work and seem to get a problem every time i use
subtotals,
i use level 2 of the subtotals (up to here it is ok ) and then place the
values in descending order. each time i do this "Grand Total" appears on the
first line and gives an error.can any one suggest a reason for this.

at home i use excel 2003 and no problems
--
alexanderd

--

Dave Peterson