How to install Excel AddIns?

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 4.67 out of 5)
Loading...

Install an Excel AddIn if you want it to open together with every Excel Workbook you create. Installation is not required if you want to use the AddIn once.

Using an Excel AddIn once

Simply open the Add-in. If you do not see the new menu item in the ribbon see how to enable an AddIn below.

How to install an Excel AddIn?

Add your AddIn to your AddIns folder

To install Excel AddIns you need to add them to your AddIns Microsoft folder. Save the Excel file to:

C:/Users/[YOUR_USERNAME]/AppData/Roaming/Microsoft/AddIns/

Remember to replace YOUR_USERNAME with your actual Windows username first.

Open Exel

Open a Excel Workbook and check if the Excel AddIn is installed properly. A new Ribbon tab or group should appear in your Excel Ribbon.

Enable the AddIn if needed

Usually this step is not required. However if you can’t find your Excel AddIn in the Ribbon try proceeding as follows. Go to the Developer tab Enable the Add-In from the Developer ribbon and go to the Add-Ins group. Select the Add-Ins button to see the list of available Excel AddIns.
Install Excel SQL AddIn
Look for your AddIn and select it. Click OK and that’s it!

10 thoughts on “How to install Excel AddIns?”

    1. Thanks for visiting Taras!

      Unfortunately no :(, currently I am not planning to save create a separate version in 2003. But keep a look-out on my Twitter/Facebook!

    1. Hi Rohit,
      frankly I haven’t tested any of my AddIns on Mac. Have you tried running any of them? My AddIns (apart from the VBA Compiler) as simple XLAM files which can be run like any other Excel Workbook.

      In case you get errors do let me know on my Forums.

  1. Hi,

    same problem as Chung Soon Wee. I’m using Excel 2007 (italian). I don’t see the SQL Addin tab on the Ribbon and there is no add-ins section on developer tab….
    Looking at the VBA code of the plugin I don’t see anything related with a ribbon tab. May be the downloaded file is missing something.

    Greetings in advance

    Luigi Croce

Leave a Reply

Simply the best place to learn VBA!

Error: Please enter a valid email address

Error: Invalid email

Error: Please enter your first name

Error: Please enter your last name

Error: Please enter a username

Error: Please enter a password

Error: Please confirm your password

Error: Password and password confirmation do not match