When I switch from automatic calculation to manual calculation, I'm accustomed to seeing the word ‘calculate’ in the lower left grey area of Excel after I make any changes to any cell. However, I’m also accustomed to seeing that word disappear after I press the F9 key and the workbook calculates.

I’m concerned because the word ‘calculate’ does not disappear even immediately after pressing the F9 key and watching Excel count up as it “calculates cells” I’m afraid not every cell is calculating. Might the size of the file cause this? My file is around 38MB. Also, none of the cells are formatted as text, they are all a custom format (so that zeros are returned as “-“).

Any help (or just comforting words) would be appreciated.