Must save to view formula results   

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

date: Wed, 15 Oct 2008 09:50:03 -0700   author:   S R S

RE: Must save to view formula results   

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

date: Wed, 15 Oct 2008 09:55:04 -0700   author:   John C johnc@stateofdenial

Re: Must save to view formula results   

Tools>options>calculation make sure it is automatic

-- 


Regards,


Peo Sjoblom

"S R" <S R@discussions.microsoft.com> wrote in message 
news:B7EE4784-7331-4F2C-99A2-C078794676DD@microsoft.com...
> 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

date: Wed, 15 Oct 2008 09:55:48 -0700   author:   Peo Sjoblom

Re: Must save to view formula results   

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

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

"S R" <S R@discussions.microsoft.com> wrote in message 
news:B7EE4784-7331-4F2C-99A2-C078794676DD@microsoft.com...
> 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
>

date: Wed, 15 Oct 2008 17:58:12 +0100   author:   Charles Williams

RE: Must save to view formula results   

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

date: Wed, 15 Oct 2008 10:09:01 -0700   author:   S R

RE: Must save to view formula results   

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

date: Wed, 15 Oct 2008 10:21:02 -0700   author:   Mike H

RE: Must save to view formula results   

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

date: Wed, 15 Oct 2008 10:38:01 -0700   author:   John C johnc@stateofdenial