Excel Link

Saved Worksheets

• When you open an Excel worksheet that contains Excel Link functions, Excel tries to execute the functions from the bottom up and right to left, thus possibly generating cell error messages (#COMMAND!, #NONEXIST!, etc.). Such behavior is usual for Excel. Simply ignore the messages, close any MATLAB figure windows, and reexecute the cell functions one at a time in the correct order by pressing F2, and then Enter.
• If you save an Excel worksheet containing Excel Link functions and later open it under a different computer environment where the excllink.xla add-in is in a different location, Excel may display a message box.
  
  

• Click No. Then pull down the Edit menu and select Links. In the Links window, click Change Source. In the Change Links window, find and select excllink.xla under <matlab>/toolbox/exlink and click OK. Excel executes each function as it changes its link. You may see MATLAB figure windows and hear error beeps as the links change and functions execute; ignore them. Back in the Links window, click OK. The worksheet now correctly connects to the Excel Link add-in.

  Or, instead of using the Edit Links... menu, you can manually edit the link location in each affected worksheet cell to show the correct location of excllink.xla.

Data Types

Using Excel Link