Originally posted by: Phil05

Hello,

I'm using Excel 2013 and CPLEX 12.5. System is Windows 7 Home premium SP1, 64bit.

The first time I add the CPLEX add-in with the file "cplex125.xll", the dialog was done but cplex is not shown in the Add-in tag.

Then after restarting Excel, automatically it asks "the file format and extension of 'cplex125.xll' don't match. The file could be corrupted or unsafe. Unless you trast its source, don't open it. Do you want to open it anyway?"

I chose Yes and excel displays a file with messy codes. Just copy a small piece:

I have reinstalled excel and cplex and set the non-unicode language to English (US).

Has this happened? How to solve the problem? Thanks!

Phil

Originally posted by: T_O

Do Excel and CPLEX have the same architecture (32-/64-bit)?

Originally posted by: Phil05

I think they do. I just re-installed both today. They windows system is 64 bit. I put cplex in the "Program Files (x86)" folder. Yesterday it was under "Program files" folder before I uninstalled it.

Originally posted by: T_O

This doesn't answer the question. Is CPLEX 32-bit or 64-bit? In doubt, please provide the name of the installer file. For Excel, you can check this in the menu (depends on your language, should be something like file -> account -> info).

Originally posted by: Phil05

name of cplex install file:

cplex_studio125.win-x86-64

office: 

32-bit.

so it seems a mismatch. how can i tackle this? Thanks.

Originally posted by: T_O

There is a 64-bit version of Office 2013. You could install it.

You could also try to install the 32-bit version of CPLEX, but performance might degrade.

By the way: Why don't you use CPLEX 12.6.1?

Originally posted by: Phil05

re-installed office with 64 bit and it worked. Thanks a lot!