Excel recalculation

I have a Excel sheet where some cells recalculate automatically and others do not and require a F9 to recalculate.  It is interesting that several totals recalculate automatically even where data ce...