This walkthrough is for situations when the Analytic Solver or XLMiner tabs in Excel are either missing or you need to add/register the addons for additional users besides the Administrator account. If the tabs are missing (and was previously there, please skip to steps ‘Auto Load Addin’ or ‘Manual Load Addin’). For domain users, please skip to ‘Auto Load Addin’ or ‘Startup Script’ to register the addon for multiple users.
Admin and User Accounts
When installing Analytic Solver within an Administrative account, the addon will be registered and hopefully shown within that Admin account. Yet when logging in under the User account it will most likely be missing. The reason for this is that you’ll need to register the addon under that specific account for the user to have access.
There are three methods you could load this in for your other user(s). Its recommended you use the ‘Auto Load Addin’ option below first for it to be correctly loaded and remain registered in Excel
Log on to the User Account.
Auto Load Addin
Make sure Excel is closed.
This is where the registration program (for Analytic Solver Platform/XLMINER) is accessible on a Windows 7/8/10 64bit machine (So open up this directory in Windows Explorer/My Computer then your local disk or C drive)
C:\Program Files (x86)\Frontline Systems\Analytic Solver Platform\Bin\RegRSPAddin.exe
Run this program and hit the 'Register RSP' button. Click ok on the confirmation dialog box.
From here a reboot of the machine is recommended. Then re-open Excel and see if it’s listed.
Manual Load Addin
Another method would be to load it through COM Addins under the Developer tab within Excel.
Startup Script (good for Lab installs or Domain Accounts with multiple users)
The name of this register program is here (depending if you are using 32bit or 64bit):
C:\Program Files\Frontline Systems\Analytic Solver Platform\Bin\RegRSPAddin.exe
(Might need to adjust the location based on 32bit/64bit)
Here is the command usage when adding to a login script.
Usage: RegRSPAddin [/s] [/r] [/u]
/r or /reg or /register or -r or -reg or -register registers ASP/XLMINER add-in
/u or /unreg or /unregister or -u or -unreg or -unregister unregisters ASP/XLMINER add-in
/s or /silent doesn’t show message boxes. Registers ASP/XLMINER add-in silently
/? or /help or /h shows this help string
To register: RegRSPAddin /r /s
To unregister: RegRSPAddin /u /s
pathC:\Program Files\Frontline Systems\Analytic Solver Platform\Bin\RegRSPAddin.exe /r /s
Create a shortcut to C:\Program Files\Frontline Systems\Analytic Solver Platform\Bin\RegRSPAddin.exe added the switches /r /s and placed it in the "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\." directory.