• Volatile functions recalculate when any cell changes or when the F9 key is pressed. • Nonvolatile formulas recalculate only when a referenced input cell changes. • Excel functions RAND() and NOW() are examples of built-in volatile functions. • Volatile functions are typically used to run simulations in Excel. • You can use the CALC worksheet function to use Mathematica-generated random numbers within Excel-based simulations. • Example: =CALC(EVAL("Random[Integer,{1,6}]")). • You can use the CALC worksheet function to "tag" specific functions to respond when F9 is pressed or when ExcelCalculate is called from Mathematica code. • Example: =CALC(EVAL("Set", "stockprice", G10)). • Note: Volatile functions recalculate frequently and can, therefore, significantly slow down recalculation and editing operations in your spreadsheet. To avoid any potential problems, use volatile functions sparingly and, if needed, disable them when making modifications to your spreadsheets. |
