Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) | |||
Module updating of Protected Cells | Excel Discussion (Misc queries) | |||
Locked cells not updating | Excel Worksheet Functions | |||
Excel 2003 isn't updating my cells | Excel Worksheet Functions |