Does Automatic Calculation mode work?

If excel is confused about whether it should recalculate a formula, this
sometimes wakes excel up and stops the confusion.

Select all the cells on that sheet
(ctrl-a a few times should do it)

Edit|replace
what: = (equal sign)
with: =
replace all

Excel will see that you're changing all your formulas and know to recalc each
because of the change.

Thanks wrote:

I have a large number of array formulae in my sheet. I update the supporting
data and the formulae do not recalculate. The only way i can get a recalc is
to F2 and then ctrl+shift+enter. How can I get all of the formulae to
recalc. Manual recalc does not work.

--

Dave Peterson