Interrupting A Worksheet Calculation

Is there a way to stop the calculation in the worksheet ?

Some of my worksheets take a while to calculate and occaisionally I need to
stop them to attend to something else.

Thank you in advance.

Carl,

No. Kill the Excel process, or just wait.

HTH,
Bernie
MS Excel MVP


"carl" <carl@discussions.microsoft.com> wrote in message
news:3ACFC170-11A1-4C53-81D6-1F8C71E7DB0B@microsoft.com...
> Is there a way to stop the calculation in the worksheet ?
>
> Some of my worksheets take a while to calculate and occaisionally I need to
> stop them to attend to something else.
>
> Thank you in advance.

In my copy of Excel (2002), if I use the mouse or the arrow keys to select a different cell, it will usually halt calculation (sometimes there's a delay), put "Calculate" in the status bar, and wait until I leave the cursor still for short time, then will restart calculating.

If this is a frequent annoyance, you may consider setting calculation to manual (Tools-> Options->Calculation->check manual).