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: If the above does not work
Open a command prompt with administrator privileges - click the Start Button (bottom left of your screen) and in the search dialog box type in cmd, the top option from there should be Command Prompt. Right click this and select Run as Administrator.
In the command prompt window type the following commands (one at a time, pressing enter after each command to execute it. Do not enter the – or any text after it, these are just descriptions/hints):
-Press tab to auto fill to Program Files
-Press tab to auto fill to Frontline Systems
-If it does not auto-fill to Frontline Systems type in cd .. and press enter to go back
--type in cd Program
---Press tab twice, this should auto-fill to program Files (x86) instead, then try cd front and press tab to auto-fill to Frontline Systems
-Press tab to auto fill to Analytic Solver Platform
Once this is done you should get a pop up message indicating that the command completed successfully and the dll is registered. Follow the steps in Procedure 1 above to ensure the add-in is fully "activated".
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
Example script entry:
C:\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.