Progress of calculation

[Lee Kennedy]

With the previous version of Excel the cell value would show the
interim value during loop-driven calculations. I found this very
useful to be able to see that things were actually happening and to
monitor the progress of calculations.

With Excel 2004 the cell holds the original value until the calculation
cycle is complete.

Is there a way of convincing the cell to display the interim values as
a loop-driven calculation progresses?

 

[Bob Greenblatt]

With the previous version of Excel the cell value would show the
interim value during loop-driven calculations. I found this very
useful to be able to see that things were actually happening and to
monitor the progress of calculations.

With Excel 2004 the cell holds the original value until the calculation
cycle is complete.

Is there a way of convincing the cell to display the interim values as
a loop-driven calculation progresses?

Are you talking about from within a macro? I just played with this a bit and
it looks like this was removed to improve performance. Placing
Application.screenupdating in the loop also does not update the cell
contents, BUT really slows down macro execution. Adding a doevents does
allow the cell to update, but again makes the execution REALLY slow.

 

[Lee Kennedy]

Yes, macros. I have some that tend to be a bit large and it would be
nice to see what is happening during running - eg are they nearly
done?, are they aactually doing what I want? A (very) dirty solution
is to move the mouse to the screen saver hot corner and then away
again. The sreen refreshes with current values but it is far from
elegant!

Lee.

 

[Jim Gordon MVP]

Hi,

Have you tried putting the value in the status bar? I haven't tried
lately, but last time I did that would display very fast.

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

Yes, macros. I have some that tend to be a bit large and it would be
nice to see what is happening during running - eg are they nearly
done?, are they aactually doing what I want? A (very) dirty solution
is to move the mouse to the screen saver hot corner and then away
again. The sreen refreshes with current values but it is far from
elegant!

Lee.