This article describes the formula syntax of the MONTE.CALCULATION function.
Get or set calculation mode. Default is MONTE_CALCULATE_DOCUMENT.
mode is the calculation mode from MONTE_CALCULATE_*.
XllMonte can be set to only calculate the active sheet (
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
in order for the references to be updated.