Options: Formula

In the Formula tab of the Options dialog box, you can set automatic/manual computation methods and formula options.

Steps

To calculate now

  1. Click File > Options.
  2. In the Options dialog box, select the Formula tab.
  3. In Computation Method, click Calculate Now.
  4. The dialog box closes and all values and formulas in the open worksheet are recalculated.

More Information

Formula Tab of Options Dialog Box

Computation Method

To calculate in a Cell worksheet, select a computation method.

Formula Options

See Also