Wednesday, April 27, 2011

EXCEL: Calculations Not Working?

If you have calculations in an Excel spreadsheet that aren't calculating until you save the workbook, try this:

  1. Tools
  2. Options
  3. Calculation.... if this is set to "manual" change it to "automatic"
Your calculations should now work as they are entered into the cells.

No comments:

Post a Comment