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 |
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 |