Excel Link will not function properly if the version of the Excel Link add-in does not correspond to the version of MATLAB. To determine if you are using the correct version of the Excel add-in, please do the following.
1. At the MATLAB command prompt execute the command
ver
2. Examine the output to find the line corresponding to Excel Link and note the version number.
3. In Excel, open the "Tools->Add-Ins..." dialog box and inspect the Version number of the Excel Link Add-In.
4. The Major and minor revision numbers should agree.
NOTE: The version in MATLAB may include a sub minor revision which does not need to agree. For example, for Excel Link 2.3.1 (R2006a) the add-in version reported in Excel is 2.3. This is correct version.
If the version does not match, please update the Excel add-in by using the following steps:
1. Click on the "Browse" button in the Excel Add-Ins dialog box
2. Select the $MATLABROOT\toolbox\exlink\excllink.xla file (where $MATLAB is the MATLAB root directory on your machine, as returned by typing
matlabroot
at the MATLAB Command Prompt.)
3. Click "OK."
4. If you are prompted to replace an existing file click "Yes."
5. Click "OK" in the Add-Ins dialog box to complete the process.
