Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Excel and MSVDM (XP Powertoys) | Excel Discussion (Misc queries) | |||
Excel ver 10 "Encounters a Problem" on starting | Excel Discussion (Misc queries) | |||
Problem pasting numeric data from Access into Excel | Excel Discussion (Misc queries) | |||
Excel problem with web based spreadsheets | Excel Discussion (Misc queries) | |||
Staring Excel Problem | Excel Discussion (Misc queries) |