I have a rather large Excel file of approx 26 Mb.
It contains around 150 worksheets which are all filled with formulas
(if-formulas, sumif-formulas, lookups and so on). Because of the scale of the
file I have selected manual calculation (F9) under Tools/options/calculation,
so it is easier to work with.
I have from time to time experienced that Excel does not respond to F9, even
though there are cells that are not yet calculated.
I press F9 and nothing happens. Then I locate a cell which I know has to be
calculeted. I enter into it by pressing F2 and then I exit it again without
making any changes. Now this cell is calculated correctly.
This is however not a perfect sollution, as it requires knowledge of which
cells that have to be calculated.
I have also tried to select all 150 sheets and replace "=" with "=". This
way all formulas should be activated, and thereby calculated. This is however
a very slow process.

I do not know if this is because the file is so big, or if Excel has an error

Does anyone have experienced same or have another sollution to the problem