How to Enabling the Infor Q&A or Add-Ins in Excel



Open C:\Program Files (x86)\Infor\Query and Analysis\ExcelAddinRemoveAdd (double click)




Tick the Microsoft Excel Box and then the Apply Button




Open up Microsoft Excel and make sure “Infor Q&A” or “Add-Ins” appear



If Infor Q&A or Add-Ins doesn’t appear, follow the next steps. Open up Microsoft Excel, Click on File, then Options.



Choose the Add-ins tab on the left. At the bottom of box-Manage: COM Add-Ins and click the Go button.



Tick the Infor Query and Analysis Add-In box and click OK.



The following tab should then appear in your Menu Ribbon








How to Update Application Role


STEP 1


Open User Manager, Enter Username and Password then click OK



Settings – SunSystems 5- Manage Application Role





Fill Application Role Name, Application Role Password, Re-enter Password, OK, OK






STEP 2 

You need to continue with STEP 2 if you do fail in STEP 1
Usually, the problem was in Password Policy as you see in next image


continue next step.....
Search and Open Local Security Policy, "change Password must meet complexity requirement" from Enable to Disable



Change to Disable - Apply - OK


Go back to STEP 1