software

Hi,

Excel automatically calculates cells which I don't need so I went to
Tools gt; Options gt; Calculations and changed it to manual calculation.
But from time to time for some reason, Excel switches back to automatic
calculation. Is there any reason for this and anyway I can avoid this
from happening?

Thanks--
workerboy
------------------------------------------------------------------------
workerboy's Profile: www.excelforum.com/member.php...oamp;userid=34121
View this thread: www.excelforum.com/showthread...hreadid=542130Hi workerboy.

Whether Auto Calc is on or off is determined by the first spreadsheet you
open during the session.
Hope this helps.
Andy.

quot;workerboyquot; gt; wrote
in message ...
gt;
gt; Hi,
gt;
gt; Excel automatically calculates cells which I don't need so I went to
gt; Tools gt; Options gt; Calculations and changed it to manual calculation.
gt; But from time to time for some reason, Excel switches back to automatic
gt; calculation. Is there any reason for this and anyway I can avoid this
gt; from happening?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; workerboy
gt; ------------------------------------------------------------------------
gt; workerboy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34121
gt; View this thread: www.excelforum.com/showthread...hreadid=542130
gt;

Thanks for the help Andy. I guess i'll just make an auto open macro that
changes it to manual each time.--
workerboy
------------------------------------------------------------------------
workerboy's Profile: www.excelforum.com/member.php...oamp;userid=34121
View this thread: www.excelforum.com/showthread...hreadid=542130Another possibility is a macro that changes calculation to manual before it
starts processing, and then, assuming that calculation had been automatic
before it started (which in your case would be an incorrect assumption)
changes calculation to automatic.

--
Kevin Vaughnquot;workerboyquot; wrote:

gt;
gt; Thanks for the help Andy. I guess i'll just make an auto open macro that
gt; changes it to manual each time.
gt;
gt;
gt; --
gt; workerboy
gt; ------------------------------------------------------------------------
gt; workerboy's Profile: www.excelforum.com/member.php...oamp;userid=34121
gt; View this thread: www.excelforum.com/showthread...hreadid=542130
gt;
gt;