Every now and then, My workbook won't auto update so I'm stuck going to every effected cell double clicking it and pressing enter. Just wondering if this can be corrected or if its another one of Microsofts bugs.
Sometimes when you're low on memory, Excel reverts to manual recalc (I think it still does this - maybe someone else can verify). If this happens intermittently, consider closing down other apps. You can tell if you are getting into manual recalc mode if you see the word Calculate appearing down in the Status bar.
Formulas, and if the Autocalc feature is defaulted on then I've never touched it. Just to explain it quickly : I have a monthly spread of hours in columns 2-7 with a sum of them in column 1, when I change a spread in say column 3, 1 should update to reflect the hours but it stays static until I double click the cell and hit enter.