Step 1: Select the “ File ” tab. Step 2: In the File menu, choose “ Options ” from the file menu. Step 3: The “ Excel Options ” window opens. On the left, click the “ Add-ins” option, on the right, the “ Manage” field should be “ Excel Add-in ” [If not, select from the drop-down], click on “ Go… ”, as shown below.

Install and use Excel add-ins to get extra features and commands in your Excel workbooks. See how to unblock new add-ins that are not working, due to Microsoft security settings. Usually, Excel add-ins are installed in Excel's default folder for Add-ins. If you prefer to store add-ins in a different folder, go to the Use a Different Folder section.

If you cannot find the add-in that you want to activate in the Office Add-Ins box, you may need to install it. To install an add-in that is typically installed with Excel, such as Solver or the Analysis ToolPak, run the setup program for Excel or Microsoft Office and choose the Change option to install the add-in.

Go to the File tab > Save as section. Select Excel Add-in (*.xlam) from the dropdown. Excel automatically selects the Add-in folder. Click Save. Usually, Excel stores the add-ins in its default folder. You can store the add-ins in a different folder. Click File tab > Options from the menu list.