Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gmasson
 
Posts: n/a
Default Excel Subtotal problem

I just updated a group of users from Excel XP (2002) to Excel 2003, current
service patch. They are running into an issue with Subtotals:

Multilevel subtotals are in the wrong position.

Example. I sort a worksheet by three levels using DataSort, then subtotal
three times using DataSubtotal, the same fields used to sort, the sum
function and do not have the Replace Current Subtotals box checked. On the
previous version of Excel the subtotals were then nested in the correct
order, on the new version some are and some arent, the ones that arent have
their first total in the second level.


Thanx

Guy M
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Excel Subtotal problem

See

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"gmasson" wrote in message
...
I just updated a group of users from Excel XP (2002) to Excel 2003,

current
service patch. They are running into an issue with Subtotals:

Multilevel subtotals are in the wrong position.

Example. I sort a worksheet by three levels using DataSort, then

subtotal
three times using DataSubtotal, the same fields used to sort, the sum
function and do not have the Replace Current Subtotals box checked. On the
previous version of Excel the subtotals were then nested in the correct
order, on the new version some are and some aren't, the ones that aren't

have
their first total in the second level.


Thanx

Guy M



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
Problem with Excel and MSVDM (XP Powertoys) Hinne Excel Discussion (Misc queries) 3 March 23rd 06 03:11 AM
Excel ver 10 "Encounters a Problem" on starting Ken McLennan Excel Discussion (Misc queries) 6 July 19th 05 01:51 PM
Problem pasting numeric data from Access into Excel JP Jones Excel Discussion (Misc queries) 8 July 14th 05 03:26 PM
Excel problem with web based spreadsheets Steve Williams Excel Discussion (Misc queries) 0 January 12th 05 02:11 PM
Staring Excel Problem Everton Excel Discussion (Misc queries) 1 November 26th 04 09:22 PM


All times are GMT +1. The time now is 11:52 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"