Hi everyone!
We detected an important issue regarding the RQA connection to Microsoft Excel requirements repository: Microsoft Office 2016 technology that allows RQA extract the information from Excel workbooks (.xlsx format) has changed from previous versions. Unfortunately, this means that RQA does not work with .xlsx format documents created by Excel 2016.
The solution is to install the Microsoft Access Database Engine 2010 Redistributable:
www.microsoft.com/en-us/download/details.aspx?id=13255
You have to select the same architecture than your current Office 2016 software (32 bits or 64 bits).
UPDATE: we have discovered that, even installing the 64 bits version, it is necessary to install the 32 bits version. The reason behind that is that RQA is workng on 32 bits architecture and Office is on 64 bits.
However, it is not as simple as just double-clicking in the file, because it will warm you that your current version of Office is 64 bits. In that case, it is necessary to run the file by command line, using this command:
AccessDatabaseEngine.exe /passive
The /passive command will run the file without interaction with the user, so it won't warm you as the last time.
And finally, to make it work in RQA, you have to quit the application and start it again.
Now the problem is solved!
Cheers!
