I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and suddenly
this happened.
Excel 2003, SP3, Office Professional

Check Tools|Options, Calculation tab, and ensure the Automatic calculation is
checked.

This is excel wide, not workbook specific, so, if you open a book that has
manual calculations, any other books you open after that (with the first one
still open), will switch to manual calculations. The reverse is also true.
The first workbook opened determines how any subsequent workbooks will
calculate.

Hope this helps.
--
John C


"S R" wrote:

I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and suddenly
this happened.
Excel 2003, SP3, Office Professional

Toolsoptionscalculation make sure it is automatic

--


Regards,


Peo Sjoblom

"S R" <S wrote in message
...
I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and
suddenly
this happened.
Excel 2003, SP3, Office Professional

Sounds like Calculation is set to Manual:
Try Tools--Options--Calculation--Automatic

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"S R" <S wrote in message
...
I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and
suddenly
this happened.
Excel 2003, SP3, Office Professional

Thanks. This looks to be the fix. I must have opened a spreadsheet set to
manual prior. Thanks again!

"John C" wrote:

Check Tools|Options, Calculation tab, and ensure the Automatic calculation is
checked.

This is excel wide, not workbook specific, so, if you open a book that has
manual calculations, any other books you open after that (with the first one
still open), will switch to manual calculations. The reverse is also true.
The first workbook opened determines how any subsequent workbooks will
calculate.

Hope this helps.
--
John C


"S R" wrote:

I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and suddenly
this happened.
Excel 2003, SP3, Office Professional

and just to add the reason saving updates things is that save forces a
calculate

Mike

"S R" wrote:

I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and suddenly
this happened.
Excel 2003, SP3, Office Professional

You are welcome, thanks for the feedback. :)
--
John C


"S R" wrote:

Thanks. This looks to be the fix. I must have opened a spreadsheet set to
manual prior. Thanks again!

"John C" wrote:

Check Tools|Options, Calculation tab, and ensure the Automatic calculation is
checked.

This is excel wide, not workbook specific, so, if you open a book that has
manual calculations, any other books you open after that (with the first one
still open), will switch to manual calculations. The reverse is also true.
The first workbook opened determines how any subsequent workbooks will
calculate.

Hope this helps.
--
John C


"S R" wrote:

I'm doing a sum on a single column of numbers =sum(d3:d50). After updating
new values to the column I now must save the worksheet to view the updated
formula results. I've been using this worksheet for over a year and suddenly
this happened.
Excel 2003, SP3, Office Professional