ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Subtototal display is in different order than 2002, why? (https://www.excelbanter.com/excel-worksheet-functions/74244-subtototal-display-different-order-than-2002-why.html)

Charles

Subtototal display is in different order than 2002, why?
 
The order of my subtotals in version 2003 is different that=n 2002. The
first subtotal should be shown first and the subsequent subtotal should be
shown above the first, the next above the second etc.
With 2003 the second subtotal is below the first and the third is above the
first. Help!

JE McGimpsey

Subtototal display is in different order than 2002, why?
 
Did you uncheck the "Summary below data" checkbox in the Subtotal dialog?


In article ,
"Charles" wrote:

The order of my subtotals in version 2003 is different that=n 2002. The
first subtotal should be shown first and the subsequent subtotal should be
shown above the first, the next above the second etc.
With 2003 the second subtotal is below the first and the third is above the
first. Help!


Dave Peterson

Subtototal display is in different order than 2002, why?
 
Maybe...

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

Charles wrote:

The order of my subtotals in version 2003 is different that=n 2002. The
first subtotal should be shown first and the subsequent subtotal should be
shown above the first, the next above the second etc.
With 2003 the second subtotal is below the first and the third is above the
first. Help!


--

Dave Peterson

Charles

Subtototal display is in different order than 2002, why?
 
Thanks for you reply.

Not on the first subtotal but yes on subsequent substotals. The substotal
display is still not in the order I think is logical as in the other version
of excel.

I can send you the file three (3) different ways (a).with the subtotals
with this version, (b.)subtotals with a prior version which is the subtotal
display I perfer and (c.) without subtotals.

Charles




"JE McGimpsey" wrote:

Did you uncheck the "Summary below data" checkbox in the Subtotal dialog?


In article ,
"Charles" wrote:

The order of my subtotals in version 2003 is different that=n 2002. The
first subtotal should be shown first and the subsequent subtotal should be
shown above the first, the next above the second etc.
With 2003 the second subtotal is below the first and the third is above the
first. Help!


Charles

Subtototal display is in different order than 2002, why?
 
Dave,

Thanks, did the suggested steps (1 through 9) and the subtotal order below
the data are in the correct order.

"Dave Peterson" wrote:

Maybe...

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

Charles wrote:

The order of my subtotals in version 2003 is different that=n 2002. The
first subtotal should be shown first and the subsequent subtotal should be
shown above the first, the next above the second etc.
With 2003 the second subtotal is below the first and the third is above the
first. Help!


--

Dave Peterson



All times are GMT +1. The time now is 01:46 AM.

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