Calculation - set to automatic for one workbook - manual for anoth
 

Is it possible to have 2 workbooks open with Automatic calculation for one
and manual calculation for the other? Thanks.

Calculation - set to automatic for one workbook - manual for anoth
 

The calculation setting applies for the Application and so it will be
applicable for all open workbooks..
--
If this post helps click Yes
---------------
Jacob Skaria


"dhstein" wrote:

Is it possible to have 2 workbooks open with Automatic calculation for one
and manual calculation for the other? Thanks.

Calculation - set to automatic for one workbook - manual for anoth
 

Here you can find the explanation on how calulation mode works.

http://support.microsoft.com/kb/214395


"dhstein" wrote:

Is it possible to have 2 workbooks open with Automatic calculation for one
and manual calculation for the other? Thanks.