Why are my functions not executing?

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I spent all this time building a workbook, and now when I enter new data,
none of the calculations happen. If I click on the individual cell with the
function in it and then hit enter, then it works. What's going on?
 
Make sure Calculations are set to Automatic.

In Excel 2003:
Goto TOOLS-->OPTIONS-->CALCULATIONS-->Check "Automatic"

In Excel 2007:
Goto the Formulas Tab, then click on the Calculation Options button. Check
Automatic.

HTH
Elkar
 
Back
Top