I am used to Excel 2003 automatically updating formulas. For example, in
calculating grades, I use this:
=A6*0.05+B6*0.1+C6*0.05+D6*0.15+E6*0.15+F6*0.25+G6 *0.25

In 2007, I have noticed that changing any number in one of the cells given
above (A through G 6) will not automatically change the sum in the last cell
(in this instance, G7, where I have this code/formula). I have gone into the
Excel options (ForumlasCalculation Options, and then checked the button
that says Workbook Calculation: Automatic, but every time I start Excel
again, that option has been changed back to manually. Yes I do hit OK first
before closing Excel. Is there any way to get this option to stay checked
(or to get automatically updating formulas, otherwise)?

--
Paul
Vista Home Basic
Office 2007

You have a response at your other post.

Paul wrote:

I am used to Excel 2003 automatically updating formulas. For example, in
calculating grades, I use this:
=A6*0.05+B6*0.1+C6*0.05+D6*0.15+E6*0.15+F6*0.25+G6 *0.25

In 2007, I have noticed that changing any number in one of the cells given
above (A through G 6) will not automatically change the sum in the last cell
(in this instance, G7, where I have this code/formula). I have gone into the
Excel options (ForumlasCalculation Options, and then checked the button
that says Workbook Calculation: Automatic, but every time I start Excel
again, that option has been changed back to manually. Yes I do hit OK first
before closing Excel. Is there any way to get this option to stay checked
(or to get automatically updating formulas, otherwise)?

--
Paul
Vista Home Basic
Office 2007

--

Dave Peterson

Thanks Dave. I''ll just go to one excel newsgroup--like I said I hit the
panic button when I didn't see that other one listed in MS' web interface
for the communities, but obviously someone over there was able to read my
posts!

--
Paul
Vista Home Basic
Office 2007
"Dave Peterson" wrote in message
...
You have a response at your other post.

Paul wrote:

I am used to Excel 2003 automatically updating formulas. For example, in
calculating grades, I use this:
=A6*0.05+B6*0.1+C6*0.05+D6*0.15+E6*0.15+F6*0.25+G6 *0.25

In 2007, I have noticed that changing any number in one of the cells
given
above (A through G 6) will not automatically change the sum in the last
cell
(in this instance, G7, where I have this code/formula). I have gone into
the
Excel options (ForumlasCalculation Options, and then checked the button
that says Workbook Calculation: Automatic, but every time I start Excel
again, that option has been changed back to manually. Yes I do hit OK
first
before closing Excel. Is there any way to get this option to stay checked
(or to get automatically updating formulas, otherwise)?

--
Paul
Vista Home Basic
Office 2007

--

Dave Peterson