# 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.