MONTE.CALCULATION function

This article describes the formula syntax of the MONTE.CALCULATION function.

Description

Get or set calculation mode. Default is MONTE_CALCULATE_DOCUMENT.

Syntax

MONTE.CALCULATION(mode)

mode	is the calculation mode from MONTE_CALCULATE_*.

XllMonte can be set to only calculate the active sheet (MONTE_CALCULATE_DOCUMENT()) or the entire workbook (MONTE_CALCULATE_NOW()). By default only the active sheet is calculated. If the active sheet references cells in other sheets then you must set the calculation mode to MONTE_CALCULATE_NOW() in order for the references to be updated.