Formulas that contain volatile functions are recalculated every time any other function is recalculated. If the EnableCrossSheetReferences property for the control is false, then the functions are recalculated only on the sheet where the changes occur.