Tuesday, 16 December 2014

Infor Query & Analysis (Q&A): Install Excel Add-in

To install for a user with administrative rights:

Start > All Programs > Infor Query & Analysis > Maintenance > OK > Configure Microsoft Office

To install for a standard user without admin rights:

Browse to C:\Program Files (x86)\Infor\Query and Analysis
Run ExcelAddinRemoveAdd.exe
Tick Microsoft Excel and then Apply

It may also be necessary to trust the ribbon.

Open an administrative command prompt and enter:

cd C:\Windows\Microsoft.NET\Framework\v2.0.50727

CasPol.exe -ag 1 -url "file://C:\Program Files (x86)\Infor\Query and Analysis\Infor.QAA.Ribbon.dll" FullTrust


  1. tried the steps but no luck....

  2. This comment has been removed by the author.

  3. To me; browse to "C:\Program Files (x86)\Infor\Query and Analysis" and Run ExcelAddinRemoveAdd.exe for each domain account; works fine.

  4. If you are a regular Excel 2003 user, you will probably have recently become aware of increasing numbers of people using Excel 2007. You may even have been sent Excel 2007 workbooks and had problems opening them. Whatever the case, it is likely that you will, at some point, consider switching to Excel 2007. But what are the main benefits of Excel 2007 vs Excel 2003, and how much effort will be involved in making the switch? ppt translator

  5. I prefer merely excellent resources - you will see these people in: data analysis help