Apparently this has not been changed with 2007 version.

First workbook opened governs the calc mode for subsequent workbooks opened
in same session.


Gord Dibben MS Excel MVP

On Thu, 24 Jul 2008 09:13:00 -0700, John C <johnc@stateofdenial wrote:

In xl2003, if I have a workbook that has AutoCalc turned off. But I open a
separate wb with AutoCalc on, then I open the wb that had it turned off,
AutoCalc is NOW turned on. Not sure if same in xl2007.