Workbook Calculations set to Automatic - Excel 2007

[Guest]

Hi... i'm new to this forum and have looked for an answer to my question w/
no luck. I have several work sheets in my workbook that feed into a summary
work sheet. I try setting my workbook calculation to 'Automatic' under
'Excel Options' -> 'Formulas', but Excel will not 'Save' this change. Each
time i go back to check it is set to 'Manual'. The only way my formulas
update on each individual work sheet and on my summary worksheet is to hit
F9. Why doesn't it do it automatically?

Thanks for your help.

 

[Stan Brown]

Tue, 8 May 2007 16:32:01 -0700 from qualitywoodworking

Hi... i'm new to this forum and have looked for an answer to my question w/
no luck. I have several work sheets in my workbook that feed into a summary
work sheet. I try setting my workbook calculation to 'Automatic' under
'Excel Options' -> 'Formulas', but Excel will not 'Save' this change. Each
time i go back to check it is set to 'Manual'. The only way my formulas
update on each individual work sheet and on my summary worksheet is to hit
F9. Why doesn't it do it automatically?

I don't know about Excel 2007, but in earlier Excels this option is
"sticky" in workbooks. If you open a workbook that was saved under
manual calculation, any new workbooks will also be saved under manual
calculation.

I can't promise it will work, but try changing your workbook to
automatic calculation, closing Excel, and then reopening the
workbook. Let us know your results, please!

 

[Guest]

Once again i went to Excel Options->Formulas->Automatic->OK then exited out
of Excel, and was asked if i wanted to Save changes, clicked Yes. When i
went back it was still set to Manual.

Stan... Thanks for trying!