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

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

 

 

If the UPS 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 2010 or newer running on Windows operating system Windows 7 or newer.

The latest version of the UPS 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 UPS 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 UPS 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-com-add-ups-tool-disabled.png

 

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

 

5) The UPS 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 UPS 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-com-add-popup-com.png

 

8) In the COM Add-Ins window, check the UPS Excel Add-in Tool box and click the OK button.

clean-excel-add-in-click-okay.png

 

You may need to close out of Excel completely and relaunch it to see the UPS 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-add-com-add-.png

 

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

clean-excel-add-in-click-remove.png

 

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

 

Uninstall and Reinstall the Excel Tool

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

To uninstall:

1) Launch your computer's Settings or Control Panel. Click the APPS button. excel-uninstall-p1.png

 

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

excel-uninstall-tool.png

 

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

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

To reinstall:

1) Download the MS Excel Integration Tool from the Help Section.

excell-addon-install.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 UPS 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 UPS 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 UPS 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

0 comments

Please sign in to leave a comment.