MATLAB: How to resolve the issue that Spreadsheet Link Add-in in Excel is causing class not registered

fm20.dlllinkspreadsheet

When I add the Spreadsheet Link add-in into Excel, I got the following error in Excel:
Class not registered.
Looking for object with
CLSID: {C62A69F0-16DC-11CE-9E98-00AA00574A4F}
I have reinstalled MATLAB and Excel and the error still persists.

Best Answer

The error might be caused by an inproper registry of fm20.dll in the operating system.
Please follow the instruction below:
1. Please try to locate the fm20.dll file, which should be located either in C:\Windows\SysWOW64 or C:\Windows\System32
2. Exit all the programs that are running.
3. Click Start, click Run, type "regsvr32 C:\Windows\SysWOW64\Fm20.dl or C:\Windows\System32\Fm20.dll depends on which folder you found the fm20.dll, and then press ENTER.
4. Click OK.