Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 201
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display all conditional formatting in Excel? Kit Excel Worksheet Functions 16 July 12th 06 01:17 PM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 2 March 31st 06 05:11 PM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 1 March 31st 06 04:24 AM
display data as a percentage of a subtotal in excel pivot table Fl pivot user Excel Discussion (Misc queries) 2 March 26th 05 12:24 PM
"Not enough system resources to display correctly" error hwatari Charts and Charting in Excel 0 December 18th 04 02:19 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"