ExcelBanter - Manual Calculation in Excel 2007 with Calculate mode set to Automatic

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Manual Calculation in Excel 2007 with Calculate mode set to Automatic (https://www.excelbanter.com/excel-worksheet-functions/249289-manual-calculation-excel-2007-calculate-mode-set-automatic.html)

Julie White

Manual Calculation in Excel 2007 with Calculate mode set to Automatic

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

Manual Calculation in Excel 2007 with Calculate mode set to Automa

try saving the workbook after you make the change

"Julie White" wrote:

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
.

All times are GMT +1. The time now is 05:03 PM.