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.
--
John C


"duketter" wrote:

Excel 2007 - I am trying to turn off the AutoCalc function. I am also
turning it off (so it manually calculates when I press F9) in the default.
However, when I close and re-open the spreadsheet it is back on and starts
calculating right away and when I am working on it. Is there a way to turn
this off so it never calculates unless I press F9?