Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 : Group By
Hello All,
After upgradation of Ms Office to 2003. I was suppose to group the data, based on first Column, second column and then on third column. But the grouping is skipping few lines.. First Grouping is happening properly , from second onwards is the problem.My macro is having these 3 lines . "This was working fine in Excel 97". Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5, 6, 7, _ 8, 9, 10, 11, 12, 13), Replace:=False Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(5, 6, 7, _ 8, 9, 10, 11, 12, 13), Replace:=False Selection.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(5, 6, 7, _ 8, 9, 10, 11, 12, 13), Replace:=False Regards, Lakshmi |
#2
|
|||
|
|||
I don't use xl2003, but Debra Dalgleish has posted this:
======= The problem may be corrected by installing this hotfix: http://support.microsoft.com/default.aspx?id=833855 You can visit this page on the Microsoft site, to check which Office updates should be installed: http://office.microsoft.com/en-ca/of...e/default.aspx ======= And someone else posted a registry fix: http://google.com/groups?&threadm=f6...ing.google.com (one line in your browser) Look at Grant's post. Lakshmi wrote: Hello All, After upgradation of Ms Office to 2003. I was suppose to group the data, based on first Column, second column and then on third column. But the grouping is skipping few lines.. First Grouping is happening properly , from second onwards is the problem.My macro is having these 3 lines . "This was working fine in Excel 97". Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5, 6, 7, _ 8, 9, 10, 11, 12, 13), Replace:=False Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(5, 6, 7, _ 8, 9, 10, 11, 12, 13), Replace:=False Selection.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(5, 6, 7, _ 8, 9, 10, 11, 12, 13), Replace:=False Regards, Lakshmi -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Automatic links in Excel 2003 | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |