Vista and Win7 Slow

[Jeff Barnes]

Hi,

From within my app I open an .xls file and place data into cells.
Nothing fancy just code like:

oSheet:Cells( 1, 4 ):Value := "Some Data"

When running in XP I can add my data to the xls file in seconds.
For whatever reason, both Vista and Win7 are painfully slow.

I leave Excel hidden until all my data is placed then I allow Excel to visible.

It does not matter what version of Excel I try (97, 2003, 2007), they all do the same thing ... fast under XP and slow under Vista/Win7.

I have tried turning off UAC.
I have tried setting compatibility modes.

Does anyone know if there are some tweaks that can be done to solve this?

Thanks,
Jeff

 

[Jeff Barnes]

Forgot to mention:

I can open a previously created file quickly. It only slows (Vista/Win7) when trying to put data into the cells.

Jeff.

 

[Peter_SSs]

Jeff

I have moved your question to a different forum. I think the description of this forum more closely fits your problem. Whilst this forum will have less viewers, your question will also stay close to the top for longer.

I hope you get it resolved soon - sounds very frustrating!