Cells not updating
 

I'm not a total beginner when it comes to Excel, but the spreadsheet i have
just opened has linked cells, very simple stuff like: -

cell a13 =sum(a5:a11)

If i change any of the cells a5 to a11 the total in a13 does not update
unless i go to a13 push f2 and then return
This is the same between sheets of the same file, and other functions such
as: -

cell b13 =round(b2*4/17)

this won't update either unless i go to edit the cell then hit return.

Has anyone got any ideas?

Many thanks

Hi
Check that your Calculation is set to automatic. It's in
Tools/Options/Calculation tab.

--
Andy.


"Shaggyjh" wrote in message
...
I'm not a total beginner when it comes to Excel, but the spreadsheet i
have
just opened has linked cells, very simple stuff like: -

cell a13 =sum(a5:a11)

If i change any of the cells a5 to a11 the total in a13 does not update
unless i go to a13 push f2 and then return
This is the same between sheets of the same file, and other functions such
as: -

cell b13 =round(b2*4/17)

this won't update either unless i go to edit the cell then hit return.

Has anyone got any ideas?

Many thanks

Could you have manual calculation turned on? Toolsoptionscalculations set
it to automatic

--
Regards,

Peo Sjoblom


"Shaggyjh" wrote in message
...
I'm not a total beginner when it comes to Excel, but the spreadsheet i
have
just opened has linked cells, very simple stuff like: -

cell a13 =sum(a5:a11)

If i change any of the cells a5 to a11 the total in a13 does not update
unless i go to a13 push f2 and then return
This is the same between sheets of the same file, and other functions such
as: -

cell b13 =round(b2*4/17)

this won't update either unless i go to edit the cell then hit return.

Has anyone got any ideas?

Many thanks

Go to ToolsOptionsCalculation and make sure that the Automatic button is
set, not Manual.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shaggyjh" wrote in message
...
I'm not a total beginner when it comes to Excel, but the spreadsheet i
have
just opened has linked cells, very simple stuff like: -

cell a13 =sum(a5:a11)

If i change any of the cells a5 to a11 the total in a13 does not update
unless i go to a13 push f2 and then return
This is the same between sheets of the same file, and other functions such
as: -

cell b13 =round(b2*4/17)

this won't update either unless i go to edit the cell then hit return.

Has anyone got any ideas?

Many thanks

Thats the ticket, cheers all for your quick and prompt help!

James

"Peo Sjoblom" wrote:

Could you have manual calculation turned on? Toolsoptionscalculations set
it to automatic

--
Regards,

Peo Sjoblom


"Shaggyjh" wrote in message
...
I'm not a total beginner when it comes to Excel, but the spreadsheet i
have
just opened has linked cells, very simple stuff like: -

cell a13 =sum(a5:a11)

If i change any of the cells a5 to a11 the total in a13 does not update
unless i go to a13 push f2 and then return
This is the same between sheets of the same file, and other functions such
as: -

cell b13 =round(b2*4/17)

this won't update either unless i go to edit the cell then hit return.

Has anyone got any ideas?

Many thanks