Excel formatted totals

I have been using Excel for years, and the last few months I have had to click on the cell I want the total to update in.  It will not recalculate on its own.  Is there a good reason for this?  Some ...