I have a complex spreadsheet - that just started acting up.

Multiple colums utilize sum () feature. The problem is that the cells that
utilize this information as part of a formula do not update until I hit save
and close - then the fields are updated.

Any clue? I did not change any settings - spreadsheets from the past that
once worked; now do have the same issue occur.

Please Help!