Excel typically recalculates formulas only when the inputs to a formula have been changed. However, when you change the definition of a function or the value of a symbol in Mathematica, there is no way for Excel to automatically know about this change. In this case, you may want to force formulas to recalculate. To force repeated recalculation of a specific formula: Example | Description | =CALC(EVAL("Random[]")) | gives a new random number each time F9 is pressed |
Marking a formula for repeated calcuation using the CALC function. To force one-time recalculation of the current selection: To force recalculation of all link functions in the current workbook: By temporarily storing formulas as comments, you can disable recalculation on a formula-by-formula basis. You may want to do this to preserve currently calculated values or to suppress unwanted recalculation. To comment link formulas in the current selection: To uncomment link formulas in the current selection: Commenting a formula essentially freezes the formula in its currently calculated state. Commenting formulas for an entire workbook is discussed as a way of sharing a workbook with others in Sharing Workbooks. Notes • To select an entire sheet, click the upper left-hand corner of the header row, between A and 1. You can then apply selection commands to the sheet. • The CALC function can be used to generate random numbers for Excel-based simulations. |
Workbook.