CALCULATE.DOCUMENT

Macro Sheets Only

Equivalent to choosing the Calc Sheet button in the Calculation tab on the Options dialog, which appears when you choose the Options command from the Tools menu. Calculates only the active worksheet.

Syntax

CALCULATE.DOCUMENT( )

Remarks

If a chart is active, CALCULATE.DOCUMENT returns the #VALUE! error value.

Related Functions

CALCULATE.NOW Calculates all open workbooks immediately

CALCULATION Controls calculation settings

List of Command-Equivalent Functions