Auto Update Problems!

[gib6717]

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

 

[Joe4]

Are you talking about formulas or links?

Make sure that the Autocalc feature is turned on (Tools | Options | Calculation | Automatic).

 

[earlyd]

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.

 

[gib6717]

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

 

[gib6717]

Its Excel 2000 but its a brand new CPU (Pent. 4 2.5 GHz 384 MB memory) and I really dont run anything that power consuming

 

[Joe4]

Regardless of whether or not you have ever touched the autocalc feature, could you verify that it is set to Automatic, like I said above?

 

[earlyd]

When you change one of the cells, does Calculate appear in the status bar?

 

[gib6717]

Calculate did appear.. and when I checked Autocalc is was on manual.. Switched it back to Automatic and it fixed everything. Thanks guys. Is there any way to always keep it on Automatic?

 

[Joe4]

Changing it there is changing your default, so it should always keep it on Automatic now, unless you manually change it back.

 

[earlyd]

Way to go JMiskey - do you happen to know if Excel still does automatically revert to manual when memory gets low? I seem to remember that happening in some stone age spreadsheets.