CALCULATE.DOCUMENT macro

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

Return to index