software

Is there a way to stop calculation once it has started? I tend to do a lot
of huge spreadsheets. Sometimes I insert a column without remembering that I
have formula's that will need to re-calculate. I'd like to be able to stop
the calculation at least until I've done everything I need to do. But
sometimes escape does not stop the calculation and I have to wait until it is
done to move on.

I believe that if you look under toolsgt;optionsgt;calculation and set it to
manual, that might be what your looking for. It can easily be reset to
automatic if necessary.

quot;Kellyquot; wrote:

gt; Is there a way to stop calculation once it has started? I tend to do a lot
gt; of huge spreadsheets. Sometimes I insert a column without remembering that I
gt; have formula's that will need to re-calculate. I'd like to be able to stop
gt; the calculation at least until I've done everything I need to do. But
gt; sometimes escape does not stop the calculation and I have to wait until it is
gt; done to move on.

I'm hesitant to use that. I seem to have issues calculating when I need to
before I go onto the next step and then I end up with junk data. I was just
looking for a way to interupt a calculation in progress.

quot;ben simpsonquot; wrote:

gt; I believe that if you look under toolsgt;optionsgt;calculation and set it to
gt; manual, that might be what your looking for. It can easily be reset to
gt; automatic if necessary.
gt;
gt; quot;Kellyquot; wrote:
gt;
gt; gt; Is there a way to stop calculation once it has started? I tend to do a lot
gt; gt; of huge spreadsheets. Sometimes I insert a column without remembering that I
gt; gt; have formula's that will need to re-calculate. I'd like to be able to stop
gt; gt; the calculation at least until I've done everything I need to do. But
gt; gt; sometimes escape does not stop the calculation and I have to wait until it is
gt; gt; done to move on.