When does a Formula calculate your results? Are there any options? By default, the
workbook calculations are automatic.
Please Note: This is a screen shot of a spreadsheet we created in a previous lesson. Any spreadsheet will work for this review.
4. Consider This: Automatic Calculations
Go to Formulas ->Calculation.
Click on Calculation Options.
You See? The options include:
Automatic (This is the default.)
Except for Data Tables
What Else Do You See? The little buttons to the right of
Calculation Options are:
buttons are useful when the Calculation is set to Manual.
Formulas ->Calculation->Calculation Options