ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   descending subtotals (https://www.excelbanter.com/excel-programming/329137-descending-subtotals.html)

alexanderd[_9_]

descending subtotals
 
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[_5_]

descending subtotals
 
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


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com