ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Nested subtotal display error (https://www.excelbanter.com/excel-discussion-misc-queries/104025-nested-subtotal-display-error.html)

phil

Nested subtotal display error
 
Does anyone have a workaround for a nested subtotal display error.

the 1st second level subtotal appears above the 1st level subtotal (when
placing subtotal above the data). This also happens when placing the
subtotal below the data, in which case the last second level subtotal of a
nested group displays below its 1st level subtotal.

Is this a excel bug or am I doing something wrong?

Dave Peterson

Nested subtotal display error
 
Maybe...

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

Phil wrote:

Does anyone have a workaround for a nested subtotal display error.

the 1st second level subtotal appears above the 1st level subtotal (when
placing subtotal above the data). This also happens when placing the
subtotal below the data, in which case the last second level subtotal of a
nested group displays below its 1st level subtotal.

Is this a excel bug or am I doing something wrong?


--

Dave Peterson

PREVIOUS

Nested subtotal display error
 


"Dave Peterson" 來函:

Maybe...

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

Phil wrote:

Does anyone have a workaround for a nested subtotal display error.

the 1st second level subtotal appears above the 1st level subtotal (when
placing subtotal above the data). This also happens when placing the
subtotal below the data, in which case the last second level subtotal of a
nested group displays below its 1st level subtotal.

Is this a excel bug or am I doing something wrong?


--

Dave Peterson


PREVIOUS

Nested subtotal display error
 
TRY TO USE PREVIOUS VERSION OR ANOTHER NON-UPDATE (SINCENCE 2006 SEPT) PC

"Phil" 來函:

Does anyone have a workaround for a nested subtotal display error.

the 1st second level subtotal appears above the 1st level subtotal (when
placing subtotal above the data). This also happens when placing the
subtotal below the data, in which case the last second level subtotal of a
nested group displays below its 1st level subtotal.

Is this a excel bug or am I doing something wrong?



All times are GMT +1. The time now is 06:39 PM.

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