update of worksheet cell extremely slow
 

Hi!

We have a very simple VBA procedure that generates and writes random numbers
into a worksheet cell. On most of our client computers this runs as fast as
you would expect but on a few of them it takes forever. We have not been able
to figure out why. Anyone out there who knows what could make excel consume
huge amounts of cpu cycles when writing to a worksheet cell?

/MÃ¥ns

update of worksheet cell extremely slow
 

Have you done the following before execution

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

And at the end

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

HTH,
Barb Reinhardt

"MÃ¥ns TÃ¥nneryd" wrote:

Hi!

We have a very simple VBA procedure that generates and writes random numbers
into a worksheet cell. On most of our client computers this runs as fast as
you would expect but on a few of them it takes forever. We have not been able
to figure out why. Anyone out there who knows what could make excel consume
huge amounts of cpu cycles when writing to a worksheet cell?

/MÃ¥ns

update of worksheet cell extremely slow
 

I would add to that list

Application.EnableEvents = False
' your code
Application.EnableEvents = True

It is possible that there is a change event handler somewhere that is
executing every time a cell's value is changed.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 24 Mar 2009 08:04:06 -0700, Barb Reinhardt
wrote:

Have you done the following before execution

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

And at the end

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

HTH,
Barb Reinhardt

"Måns Tånneryd" wrote:

Hi!

We have a very simple VBA procedure that generates and writes random numbers
into a worksheet cell. On most of our client computers this runs as fast as
you would expect but on a few of them it takes forever. We have not been able
to figure out why. Anyone out there who knows what could make excel consume
huge amounts of cpu cycles when writing to a worksheet cell?

/Måns

update of worksheet cell extremely slow
 

Such as the Google Desktop Office automation addin

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Chip Pearson" wrote in message
...
I would add to that list

Application.EnableEvents = False
' your code
Application.EnableEvents = True

It is possible that there is a change event handler somewhere that is
executing every time a cell's value is changed.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 24 Mar 2009 08:04:06 -0700, Barb Reinhardt
wrote:

Have you done the following before execution

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

And at the end

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

HTH,
Barb Reinhardt

"Måns Tånneryd" wrote:

Hi!

We have a very simple VBA procedure that generates and writes random
numbers
into a worksheet cell. On most of our client computers this runs as fast
as
you would expect but on a few of them it takes forever. We have not been
able
to figure out why. Anyone out there who knows what could make excel
consume
huge amounts of cpu cycles when writing to a worksheet cell?

/Måns