Manual Calculation in Excel 2007 with Calculate mode set to Automatic

[Julie White]

Hello,

I'm desperate to understand why some of my s/s are in manual
calculation mode even though the options are set to Automatic
calculation. I have checked under Excel's options and the formula bar
to confirm calculation mode and cannot make the s/s change to
automatic. Any advice?

Julie

 

[gootroots]

try saving the workbook after you make the change