MATLAB: Does Excel Link refer to the Excel add-in (excllink.xla) file from MATLAB 6.1(R12.1) when I only have MATLAB 6.5(R13) and Excel Link 2.0(R13)

-setup2.0excellinkoldSpreadsheet Linkversion

I recently upgraded my MATLAB version from 6.1 to 6.5. I uninstalled MATLAB 6.1(R12.1) and deleted all the older files before installing version 6.5(R13). I also upgraded my Excel Link version to 2.0. If I try to open Excel, I get an error dialog box which indicates that Excel Link is still referring to the older version of excllink.xla file even though I do not have any folders for MATLAB 6.1(R12.1) on my computer. It appears as if Excel has hard coded the older path to excllink.xla file.
I can by-pass the error message and start Excel. I can setup Excel with Excel Link version 2.0. I can use the Excel Link for that session of Excel. But, if I close Excel and restart it, I get the same error message as before. Excel does not seem to be saving the newer Excel Link settings.

Best Answer

This problem occurs because Excel has some reference to the older version of Excel Link in its list for add-ins. To solve this problem, please follow these steps:
1. Start Excel
2. Click on Tools -> Add-ins
3. In the list of add-ins, you will find the entry for Excel Link. Un-check this entry
4. You will be notified if you want to delete this entry. Click on Yes
5. Close Excel before setting up the newer version of Excel Link.
6. Restart Excel. You should not receive the warning you have been receiving before. Now, you can set the Excel Link again for version 2.0 by choosing the excllink.xla file
Related Question