Hello-

Does your wkbk have any links to external files?

This could also be related to RAM availability, processor performance,
and/or disk condition (free space & fragmentation). The latter is especially
significant for a file of that size and complexity.

You might try increasing the number of iterations (same Options as Manual
Calc. setting) but it may not help much.

Hope this is of some use to you |:)

"Hmmmm" wrote:

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