Excel 2002 does not recalculate existing formulas

[Natasha Laughton]

Excel 2002 running on Windows 2000, does not recalculate
those cells that are dependent on other cells that contain
changed values.
10 20 30 0 60 (formula =sum(A11)
changed to:
10 20 30 10 60 (formula =sum(A11)
pressed enter after changing 0 to 10, but did not
recalculate.
Formula is only recalculated after SAVE or if focus is put
inside formula & press enter.

 

[Gary Gallagher]

Have just had a look at Charles' website
www.DecisionModels.com and used Ctrl & Alt & F9 to do a
full re-calculation. Now whenever I change some cell
information it is updating the relevant formulae.

 

[out_airborne]

Hi, try this to automatically refresh your macros

Public Sub Workbook_Open()

'
' refresh Macro
' Macro recorded 29-9-2003 by Oliver Trier
'
' Keyboard Shortcut: Ctrl+r
'
Application.CalculateFull
End Sub


Place this in the ThisWorkbook Section of the VBA Editor.

Regards,
Oliver
[out_airborne]