Workbook Calculations set to Automatic - Excel 2007

  • Thread starter qualitywoodworking
  • Start date
Q

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?

Thanks for your help.
 
S

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!
 
Q

qualitywoodworking

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top