Thursday 23 November 2017

Infor Query & Analysis (Q&A): Configure Excel add-in to load at startup

To configure the add-in to load at startup:

Close any running instances of Excel

Open Registry Editor and browse to:

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Infor Query and Analysis Add-in\

Set the value of the LoadBehavior key to 3

Close Registry Editor, open Excel and the Infor tab should be displayed in the ribbon.

To configure this using PowerShell:

Close any running instances of Excel, open a PowerShell prompt and run the following command:

Set-ItemProperty -Path "HKCU:\Software\Microsoft\Office\Excel\Addins\Infor Query and Analysis Add-in" -Name LoadBehavior -Value 3