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
.