I've been hunting around Technet and MSDN and haven't found an answer to what
the differences are between these two versions of Excel. Does anyone out
there know?

I have a grouping subtotaling routine that works on one machine and not in
another. The machine with 11.8307.8211 is a Vista machine and it works as
expected here, the 11.8169.8172 is an XP machine and it doesn't work as
expected.

The code is run from Access 2003 and uses the v11 Excel library to generate
the spreadsheet and apply some grouping to it.

11.8307.8211 is Excel 2003 SP3, with the latest major upgrade. I presume
11.8169.8172 is SP2 or SP1.

What is the code, what do you expect to happen, and what happens instead?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



MarkusB wrote:
I've been hunting around Technet and MSDN and haven't found an answer to what
the differences are between these two versions of Excel. Does anyone out
there know?

I have a grouping subtotaling routine that works on one machine and not in
another. The machine with 11.8307.8211 is a Vista machine and it works as
expected here, the 11.8169.8172 is an XP machine and it doesn't work as
expected.

The code is run from Access 2003 and uses the v11 Excel library to generate
the spreadsheet and apply some grouping to it.

I don't know what the difference is, but I'm using xl2003 SP3 under winXP Home.

It shows: 11.8307.8221



Jon Peltier wrote:

11.8307.8211 is Excel 2003 SP3, with the latest major upgrade. I presume
11.8169.8172 is SP2 or SP1.

What is the code, what do you expect to happen, and what happens instead?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

MarkusB wrote:
I've been hunting around Technet and MSDN and haven't found an answer to what
the differences are between these two versions of Excel. Does anyone out
there know?

I have a grouping subtotaling routine that works on one machine and not in
another. The machine with 11.8307.8211 is a Vista machine and it works as
expected here, the 11.8169.8172 is an XP machine and it doesn't work as
expected.

The code is run from Access 2003 and uses the v11 Excel library to generate
the spreadsheet and apply some grouping to it.

--

Dave Peterson

Hi Jon,

I got to the bottom of this. It was the Subtotalling error in 2003. I
applied the registry fix in the support note;

http://support.microsoft.com/KB/831824

And it resolved the issue.

It's bizarre, in code on my machine, the subtotalling worked fine, but if i
tried to do the subtotalling manually it broke as it did on the other machine
with 8211 version. The registry fix worked in all cases to resolve the issue
completely.

Thanks again,

Markus

"Jon Peltier" wrote:

11.8307.8211 is Excel 2003 SP3, with the latest major upgrade. I presume
11.8169.8172 is SP2 or SP1.

What is the code, what do you expect to happen, and what happens instead?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



MarkusB wrote:
I've been hunting around Technet and MSDN and haven't found an answer to what
the differences are between these two versions of Excel. Does anyone out
there know?

I have a grouping subtotaling routine that works on one machine and not in
another. The machine with 11.8307.8211 is a Vista machine and it works as
expected here, the 11.8169.8172 is an XP machine and it doesn't work as
expected.

The code is run from Access 2003 and uses the v11 Excel library to generate
the spreadsheet and apply some grouping to it.
.