# MONTE.CALCULATION function

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.