CALCULATE.NOW

Macro Sheets Only

Equivalent to choosing the Calculation tab from the Options dialog box and then choosing the Calc Now button. Calculates all sheets in all open workbooks. Use CALCULATE.NOW to calculate all open workbooks when calculation is set to manual.

Syntax

CALCULATE.NOW( )

Related Functions

CALCULATE.DOCUMENT Calculates the active sheet only

CALCULATION Controls calculation settings

List of Command-Equivalent Functions