This walkthrough is for situations when the Analytic Solver and Data Mining tabs in Excel are either missing or you need to add/register the addons for additional users besides the Administrator account.
There are two procedures to follow. Its recommended you attempt the ‘Auto Load Addin’ option below first as you may not have to do any more than that.
Procedure 1: Auto Load Addin
Log in to the Windows user account that you would like the Analytic Solver available to.
Make sure Excel is closed.
Locate the following directory on your machine:
C:\Program Files (x86)\Frontline Systems\Analytic Solver Platform\Bin
NOTE: The above directory is created if you have 32-bit Microsoft Office and 32-bit Analytic Solver was installed. If the Frontline Systems folder is not in Program Files (x86), please also check your Program Files folder.
Run the RegRSPAddin.exe program from this folder and left click the 'Register RSP Excel Add-in' button.
Click OK on the confirmation dialog box and re-open Excel, the tabs should now be available again.
Procedure 2: 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.