by Gavin » Mon Feb 29, 2016 11:11 pm
Hi Gary,
Thanks for your message. Other workbooks working is not quite the same thing, because Cymatic connects to Excel using a technique called COM interoperability, which requires certain dll files (link libraries) to be installed on your computer. These libraries are not required for other workbooks that you open normally in Excel, only for one's being opened by Cymatic when it is controlling Excel.
The error message indicates that those dll files are either missing or not properly recognised by Windows as being installed. They should be automatically included with all installations of Excel. So you must have Excel physically installed on your computer's hard drive. If you are using Excel 360 as an online service only then the files will not reside on your computer. If I understand correctly you do indeed have Excel installed on your PC?
In which case I still suggest that you try to repair Office/Excel in order to try to correct the problem of the missing Interop dll files.
Please also ensure that you do not open the Cymatic spreadsheet independently of Cymatic. In other words, you should use Cymatic to open Excel for you and connect to the workbooks, otherwise if they are also opened Excel beforehand then they will be treated as read only in Cymatic and thus cause operational issues.
Kind regards,
Gavin