It's hard to know without seeing how the formula are setup, but to
start with I would check the calculation under the "Tools - Options".
It may have been set to Manual...

Otherwise, you could try put this sub under the ThisWorkBook to force
it to calculate everytime you change  something.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
Target As Range)
Calculate
End Sub