This walkthrough is for situations when the Analytic Solver and Data Mining tabs in Excel are either missing from the Excel ribbon or you need to add/register the addon for additional users besides the Administrator account.
Solution
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.
Open your Windows Start Menu and type in ASP to "Search", the ASP Application Manager should appear at the top of the list:
Select the ASP Application Manager 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):
cd \
cd Program
-Press tab to auto fill to Program Files
cd front
-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
cd analytic
-Press tab to auto fill to Analytic Solver Platform
cd bin
regsvr32.exe rspaddin.xll
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
Example-
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.
Comments
9 comments
thank you for the info
thank u
No, it doesn't make sense. The pop up message shows the error to load .xll
Alicia Wang,
That message means that the command line prompt you are running is not in administrator mode, as Admin is required to register dll's with the regsvr32.exe command.
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.
still doesn't work...
I have done all steps but still do not see the ribbon
Lindsay,
Sorry for the delay in the response, have you started a ticket with our support team yet? If not, please email us at support@solver.com and let them know how far into the steps you've tested so we may proceed with a deeper dive into what may be going on.
Thank you,
Brandon T.
I am getting this message on executing this command on DOS Prompt: regsvr32.exe rspaddin.xll
Hi Amit,
I've created a ticket for you in our Zendesk ticket system to address this further.
If you do not see a response starting the ticket in your inbox or junk mail folder please send us an email to support@solver.com.
Please sign in to leave a comment.