why doesnt my formula cell update automatically ?

=SUM(G5:G11) if I change any cell in the range, the sum is not performed. I 
have to select the sum cell, F2 then Enter in order to get the sum to work
0
Wozza (3)
10/3/2005 4:46:01 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
186 Views

Similar Articles

[PageSpeed] 15

Check and make sure that calculation is set to automatic.

Tools>Options>Calculation

Biff

"Wozza" <Wozza@discussions.microsoft.com> wrote in message 
news:D54D1FA7-F8C3-4333-B243-34E516DE8A5D@microsoft.com...
> =SUM(G5:G11) if I change any cell in the range, the sum is not performed. 
> I
> have to select the sum cell, F2 then Enter in order to get the sum to work 


0
biffinpitt (3172)
10/3/2005 5:00:03 AM
Thanks Biff...not sure how it got set to manual!

"Biff" wrote:

> Check and make sure that calculation is set to automatic.
> 
> Tools>Options>Calculation
> 
> Biff
> 
> "Wozza" <Wozza@discussions.microsoft.com> wrote in message 
> news:D54D1FA7-F8C3-4333-B243-34E516DE8A5D@microsoft.com...
> > =SUM(G5:G11) if I change any cell in the range, the sum is not performed. 
> > I
> > have to select the sum cell, F2 then Enter in order to get the sum to work 
> 
> 
> 
0
Wozza (3)
10/3/2005 11:31:08 PM
Hi Wozza

FYI the calculation mode is set by the Calculation setting of the first 
Workbook opened in that session of Excel.
Maybe the first book you opened was from someone else, and they had the 
calculation set to manual.

Regards

Roger Govier



Wozza wrote:

>Thanks Biff...not sure how it got set to manual!
>
>"Biff" wrote:
>
>  
>
>>Check and make sure that calculation is set to automatic.
>>
>>Tools>Options>Calculation
>>
>>Biff
>>
>>"Wozza" <Wozza@discussions.microsoft.com> wrote in message 
>>news:D54D1FA7-F8C3-4333-B243-34E516DE8A5D@microsoft.com...
>>    
>>
>>>=SUM(G5:G11) if I change any cell in the range, the sum is not performed. 
>>>I
>>>have to select the sum cell, F2 then Enter in order to get the sum to work 
>>>      
>>>
>>
>>    
>>
0
roger1272 (620)
10/4/2005 8:48:46 AM
Reply:

Similar Artilces: