Troubleshooting the Solid Commerce Excel Add-In Tool When It's Not Visible

After installing the Excel Add-In Tool, you should see the Solid Commerce menu in your Excel ribbon.

excel_integration_add-in_solid_commerce_menu_button.png

 

If the Solid Commerce Excel Add-In Tool is not visible in the ribbon, please try these steps in order:

  1. Check Your Version of Excel, Windows, and the Add-In Tool
  2. Enable the Excel Tool in the COM Add-in Menu
  3. Remove the Excel Tool From the COM Add-in Menu
  4. Uninstall and Reinstall the Excel Tool
  5. Install Visual Studio

 

Check Your Version of Excel, Windows, and the Add-In Tool

We support the Excel Add-In Tool for Excel 2007 or newer running on Windows operating system Vista or newer.

The latest version of the Solid Commerce Excel Tool is: 2016.12.1007.23330

Once you are able to get the Add-In Tool to appear, you can find the version by selecting the Solid Commerce menu and clicking the About button. The tool automatically updates itself. If you don't have the latest version, please follow the steps in the Uninstall and Reinstall the Excel Tool section below.

 

Enable the Excel Tool in the COM Add-in Menu

1) Go to the File menu in Excel -> Options.

2) In the Excel Options window -> Click Add-Ins.

3) If the Solid Commerce Excel Add-in Tool is in the list of Inactive Application Add-ins, select Disabled Items from the Manage drop-down menu at the bottom of the window. Click the Go button.

excel_options_add-ins_solid_commerce_inactive_add-in_v2.png

4) In the Disabled Items pop-up, select Solid Commerce Excel Add-in Tool and click the Enable button.

excel_options_disabled_items_solid_commerce_add-in.png

5) The Solid Commerce Excel Tool should reappear in the Excel menu. If it doesn't, try closing out of Excel completely and relaunching it.

  • If it still isn't visible after relaunching Excel, skip to Step 7—managing COM Add-ins.

6) If the Solid Commerce Excel Add-In Tool is not listed in the Disabled Items pop-up, close it.

7) Select COM Add-ins from the Manage drop-down menu. Click the Go button.

excel_options_add-ins_solid_commerce_com_add-in_button.png8) In the COM Add-Ins window, check the Solid Commerce Excel Add-in Tool box and click the OK button.

excel_options_com_add-ins_solid_commerce_check_box.png

You may need to close out of Excel completely and relaunch it to see the Solid Commerce Excel Tool menu.

 

Remove the Excel Tool From the COM Add-in Menu

1) Go to the File menu in Excel -> Options.

2) In the Excel Options window -> Click Add-Ins.

3) Select COM Add-ins from the Manage drop-down menu at the bottom of the window. Click the Go button.

excel_options_add-ins_solid_commerce_active_add-in.png

3) In the COM Add-Ins window, select the Solid Commerce Excel Add-in Tool. Click the Remove button.

excel_options_com_add-ins_solid_commerce_remove.png

4) Close out of Excel completely and relaunch it. The Solid Commerce Excel Tool menu should be visible.

 

Uninstall and Reinstall the Excel Tool

Running an outdated version of the Solid Commerce Excel Tool can cause issues. The easiest solution is to uninstall the Excel Tool and reinstall it.

To uninstall:

1) Launch your computer's Control Panel. Click the Programs and Features button. solid_commerce_excel_tool_uninstall_control_panel.png

2) In the Uninstall or change a program window, select Solid Commerce Excel Tool. Click the Uninstall button.

solid_commerce_excel_tool_uninstall_button.png

3) After the Excel Tool has been removed, navigate to your Program Files (x86) folder and verify that no Solid Commerce Excel Add-In Tool files or folders remain.

  • To do so: select your C: Drive -> Program Files (x86) -> SolidCommerce. Delete the ExcelAddinTool folder if there is one.

To reinstall:

1) Download the MS Excel Integration Tool from the Dashboard of your Solid Commerce account, under the video player on the right-hand side.

solid_commerce_excel_add-in_tool_download_dashboard.png

 

2) Launch the installer and follow the wizard.

After you reinstall the Excel Tool, you can verify that you have the latest version by going to the Solid Commerce menu -> Click on the About button. We've posted the latest version of the Excel Tool at the top of this article for reference.

If it installed properly, the Excel Tool will update automatically. You should not experience any further issues.

If the Solid Commerce Excel Tool menu still isn't visible, try following the steps in the two sections above.

 

Install Visual Studio 2010 Tools

If you don't have Visual Studio installed on your computer, you will experience issues with the Excel Tool.

You can use these CNET links to download Visual Studio 2010 Tools for free:

If the Solid Commerce Excel Tool menu still isn't visible after installing Visual Studio 2010 Tools, try the steps in the three sections above.

 

Related Articles

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

4 comments
  • Very well done article. I followed it to the end and it solved my problem. Thanks

  • Thank you for letting us know. We're glad we were able to help.

  • When I go to Com Add-Ins and check the SC Tool, I get a pop up that says the add in can only be connected by the administrator. I am the only user on my computer and I am the administrator. This happened once before and I don't remember what you guys had me do.

     

  • Thank you for contacting us David.

    It sounds like the Add-In isn't recognizing that your user is the Admin. There are two things you can try:

    1. Close Excel. Launch Excel again by right clicking on the launcher and selecting Run as administrator.
    2. If that doesn't work, close Excel. Uninstall the Excel Add-In. Download the installer from your Solid Commerce account. Right click on the SolidCommerceExcelSetup.exe download and select Run as administrator. Continue with the installation.

    Please let me know if either of these options work so that I can add them to the article. If those don't work, please contact our support team. They will be happy to assist you further.

    Best regards,
    Josh

Please sign in to leave a comment.