Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically

Try selecting all the cells and then:
edit|replace
what: =
with: =
replace all

Maybe it'll wake excel up.

Archie wrote:

Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically

--

Dave Peterson

The first response didn't work, but made me think, I went to options changed
to Manual under Calculations, re-opened options and changed back to
automatic...this woke up excell...thanks for the push

"Archie" wrote:

Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically