Excel 2002 does not recalculate existing formulas

  • Thread starter Thread starter Natasha Laughton
  • Start date Start date
N

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(A1:D1)
changed to:
10 20 30 10 60 (formula =sum(A1:D1)
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.
 
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.
 
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]
 
Back
Top