Contextures

Install and Use Excel Add-ins

Install and use Excel add-ins to get extra features and commands in your workbooks

Find Your Add-ins Folder

To find your default Add-ins folder, you can use my Excel Addin Folder Path Locator file.

  1. Open the Excel Addin Folder Path Locator file, and enable macros
  2. Go to the AddinsFolder sheet
  3. Click the Show Addins Folder Location button.
  4. In cell B4, the file path will appear. For example, in Windows 10, it might be located here:
       C:\Users\UserName\AppData\Roaming\Microsoft\AddIns
  5. Click the Open Addins Folder button
  6. Windows Explorer will open, and will show the contents of the Addins Folder.

NOTE: Close Excel before making any changes to the installed Addins

Excel Addin Folder Path file

How to Install an Excel Add-In

Excel 2007 and Later

To install an add-in, please follow these steps:

  1. In Windows Explorer, open the Microsoft Addins folder on your computer.
    NOTE: If you aren't sure of the location, you can use the Excel Addin Folder Path file to find it.
  2. Unzip the add-in file, if necessary, to extract the add-in file -- it will probably have an xlam extension
  3. Save the add-in file in your Microsoft Addins folder.
    NOTE: You can store the add-in in any folder, but it's easier to install if it's stored in the Addins folder
  4. To allow Excel to open the add-in file automatically, you might need to unblock it. Right click on the add-in file and click Properties
  5. file properties

  6. If the following warning appears, click the Unblock box, to add a check mark -- "This file came from another computer and might be blocked to help protect this computer"
  7. unblock

  8. Click OK
  9. Open the Excel program

In Excel:

  1. On the Ribbon, click the Developer tab (if you don't see that tab, follow the instructions here to show it)
  2. Click the Add-ins button.
  3. In the Add-in dialog box, add a check mark to add-in's name.
    Note: If you do not see the add-in in the list, click the Browse button. Navigate to the folder where you saved the xlam file, and select the add-in file
  4. Click OK, to close the window.
  5. A new tab for the add-in might appear on the Ribbon, or a new command might appear on one of the existing tabs -- check the add-in notes, for help in locating it.
  6. If you don't see a button on the Ribbon, you can add icons to the Quick Access Toolbar, to run the macros.

Add-in Custom Tab Not Showing

2016-Jul - 28: After a recent Microsoft update, some Excel add-ins (mine and others) are not loading correctly, and their custom tabs don't appear on the Excel Ribbon. Follow the steps below, to unblock the file, and it should open correctly.

  1. Close Excel, if it is running
  2. Open Windows Explorer, and open the folder where you stored the add-in file, usually the Microsoft Addins folder.
    NOTE: If you aren't sure of the Addins folder location, you can use the Excel Addin Folder Path file to find it. Then, close Excel again.
  3. To allow Excel to open the add-in file automatically, you might need to unblock it. Right click on the add-in file and click Properties
  4. file properties

  5. If the following warning appears, click the Unblock box, to add a check mark -- "This file came from another computer and might be blocked to help protect this computer"
  6. unblock

  7. Click OK
  8. Then, start Excel, and the custom tab for the add-in should appear on the Excel Ribbon

Contextures Add-ins

The following Excel add-ins are available from Contextues:

pivot power premium

  • In any workbook, the Contextures Excel Tools add-in will help you make a quick backup, sort sheets, and many other time-saving tasks

excel tools add-in

Free Add-ins

I use a few free add-ins that make Excel even better, and asked other people what free add-ins they use, and would recommend.

I compiled a list, starting with my favourites. Maybe you'll see a few that you can download and install, and make working in Excel a bit easier.

Click here to see my list of recommended free add-ins.

Save a File as an Add-in

You can create your own add-ins, by storing macros in a file, then saving it as an add-in:

  1. Record or create one or more macros in the file
  2. On the Excel Ribbon, click the File tab, and click Save As
  3. Click the Browse button, to open the Save As window (stay in the selected folder)
  4. At the bottom, type a File Name
  5. In the Save As Type drop down, select Excel Add-In (*.xlam)
  6. The AddIns folder should be automatically selected
  7. Click Save, then close Excel
  8. To use your add-in file, follow the steps below, to install it

Related Links

Contextures Products

Free Excel Add-ins

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures

Search Contextures Sites

Search Contextures Sites

 

DVMSP

 

 

 

 

Last updated: August 1, 2016 6:49 PM