Excel Link

Worksheets

• After an Excel Link function successfully executes as a worksheet formula, the cell contains the value 0. While a function is executing, the cell may continue to show the entered formula.
• We suggest selecting Move Selection after Enter on the Excel Tools Options... Edit tab. The active cell changes when an operation is complete, providing a useful confirmation for lengthy operations.
• We recommend using Excel Link functions in automatic calculation mode. If you use MLGetMatrix in manual calculation mode, enter the function in a cell, then press F9 to execute it. However, pressing F9 in this situation may also reexecute other worksheet functions and generate unpredictable results.
• To recalculate Excel Link functions in a worksheet, reexecute each function by pressing F2, then Enter.
• Pressing F9 to recalculate a worksheet affects only Excel functions (which return a value). F9 does not operate on Excel Link functions, which perform an action.
• To "automate" the recalculation of an Excel Link function, add to it some cell whose value changes. For example:

• =MLPutMatrix("bonds", D1:G26) + C1
  

• When the value in cell C1 changes, Excel re-executes the MLPutMatrix function. Be careful, however, not to create endless recalculation loops.

• Excel Link functions expect A1-style worksheet cell references. Select A1 cell Reference Style on the Excel Tools Options... General tab.
• If you use explicit cell addresses in MLGetMatrix and later insert or delete rows or columns, or move or copy the function to another cell, edit the argument to correct the addresses. Excel Link does not automatically adjust cell addresses in MLGetMatrix.
• Enter (type) Excel Link functions directly in worksheet cells. Do not use the Excel Function Wizard; it generates unpredictable results.

Tips and Reminders

Macros