Recently moved to Excel 2010 and sum, average and count function is not updating on the status bar. it has an old calculation on it from a previous spreadsheet. all 3 are ticked on the menu and calc is on auto.

From time to time it disappears altogether too.

Any ideas?