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

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