On Dec 19, 12:58 pm, jzkall wrote:
Formulas are not calculating at all (they did previously). This is happening
in several different spreadsheets. It's almost as if formula calculating is
turned off. For example, I have this formula =SUM(E4:E38), which is
returning a zero although there is plenty of data in that range (which are
basic numbers).

I had checked some other posts, and verified that my Calculations are set
to 'Automatic, and that numbers are set to to 'General'.

I also opened the same spreadsheet on someone else's computer, and it
worked fine.

Since you claim that the same workbook calculates just fine on other
computers, it seems unlikely that there is anything wrong with the
content of the formulas.

Possible exception: if some formulas have external links, the error
could exist in the copy of the linked-to files on your system, but not
on the other computers that you tried.

I wonder: do any of the F9 methods cause the formulas to calculate?

I suspect not. I wonder if you are executing some macros when the
workbook opens that set the enableCalculation property to False. That
will disable all calculation, even manual calculation. When I played
with it, =SUM(...) does indeed return zero. It returns the expected
non-zero result when enableCalculation is set to True. I cannot see
any indication (e.g. in ToolsOptionsCalculation) that
enableCalculation is False. In fact, Automatic Calculation is still
selected.

This might not have affected the workbook on other computers either
because their macro security is set not to enable macros, or because
(guessing) your macros might have external References, and the copy of
those external files are okay on the other computers.

Try setting your macro security to Very High, save the workbook, close
all instances of Excel, and reopen the workbook.

HTH.