Why 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)?
2 次查看(过去 30 天)
显示 更早的评论
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.
采纳的回答
MathWorks Support Team
2009-6-27
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
1 个评论
Jon
2019-7-19
I had essentially the same issue and the answer above fixed it. So the important thing is that you have to first remove the reference to the old Excel Link close Excel reopen it and then do the usual installation.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!