Multiterm Convert. Error: The conversion option could not be initialised properly. The file cannot be opened in Microsoft Excel.

Question

Hi! 
 I tried to create a termbase from an MS Excel glossary using MultiTerm Convert, but when I start the conversion and select the input file and click Next an error message appears: "The conversion option could not be initialised properly. The file cannot be opened in Microsoft Excel". 
 I already saw the RWS Support Guide ( https://gateway.sdl.com/apex/communityknowledge?articleName=000008785 ), but the issue is not resolved. 
 My Pc version: Windows 10 Home 22H2 
 Multiterm version: Multiterm SR2 17.2.2.2737 
 Trados version: Trados Studio SR2 17.2.9.18688

Paul · Answer

Vincenzo Russo 
 Can you share the Excel file? 
 Also, the solution is to repair Microsoft Office so I doubt anyone is going to resolve anything here.

Paul · Answer

Vincenzo Russo 
 Thanks for your file. I can reproduce the problem and I think I know the cause... it's OneDrive. If I have the file here I get that message: 
 c:\Users\pfilkin\OneDrive - RWS\Documents\SDL\TESTING\Vincenzo Russo\Glossary.xlsx 
 If I have it here, then all is well: 
 c:\Users\pfilkin\Documents\MT Convert\Glossary.xlsx 
 I tried to making sure that the version in my One Drive folder was always available but that didn't help, the message is still there. So the answer seems to be don't use any folders that are managed by OneDrive for these files.

Paul · Answer

Vincenzo Russo 
 Then I have no idea... unless of course you are using a 64-bit version of Microsoft Office? That could be the other reason. If it's none of these things then I have no idea. Maybe a good time to rethink the format of the file in Excel and redo it so the Glossary Converter can work with it more easily instead?

Paul · Answer

Michael Schroeder 
 Well... you got me doubting myself and also the technical team so I tested on my personal laptop just now where I have never actually tried to use Convert before. I get this very same error and cannot use it. On my work laptop, I have a 32-bit install and everything is fine. Maybe check your Excel... just for my own sanity! 
 
 Go to the 'File' menu in the top left corner and select it. 
 Select 'Account' or 'Office Account' on the bottom left side of the menu. 
 Under 'Product Information,' click on 'About Excel'. 
 In the dialog that opens , you will see either:
 
 64-bit if you are running a 64-bit version. 
 32-bit if you are running a 32-bit version.

Trados Studio > 3. MultiTerm

Multiterm Convert. Error: The conversion option could not be initialised properly. The file cannot be opened in Microsoft Excel.