How To Install And Use Excel Add Or Remove Add, Get An Office Add

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

How to Install an Excel Add-In

Excel 2007 and Later

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

Use a Different Folder to Store Add-ins

Instead of storing your Excel add-in in the default Micrsoft Excel Addins folder, you can use an other folder on your computer.

To prevent problems, follow these steps to set that folder as a Trusted Location:

In Excel, click the File Tab, and click Options In the list at the left, click Trust Centre Click the Trust Center Settings button In the list at the left, click Trusted Locations If your folder is not list there, click the Add New Location button Click the Browse button Find and select your folder, and click OK Click OK again, and your folder should appear in the Trusted Location list. Click OK, twice, to close the windows.

Add-in Custom Tab Not Showing

Due to Microsoft security updates, some Excel add-ins (mine and others) might not load correctly, and their custom tabs don”t appear on the Excel Ribbon. Here are a few solutions you can try.

— Unblock the Add-in File

— Use a Trusted Location

— Check the Ribbon

Unblock the Add-in File

This is the most common solution to the missing add-in tab. Follow the steps below, to unblock the file, and it should open correctly.

Close Excel, if it is running 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

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”

Click OK Then, start Excel, and the custom tab for the add-in should appear on the Excel Ribbon Use a Trusted Location

If your add-in is not stored in the defaault addins folder, the tabs could be missing because your folder is not a Trusted Location.

Follow the instructions above, that show how to use a different folder as a Trusted Location for your add-in files.

Check the Ribbon

In one case that I”ve heard of, there was a problem with the Excel Ribbon. Try these steps, if the other solutions don”t fix the problem.

Xem thêm: Phương Trình 2 Đường Thẳng Song Song, Phương Trình Đường Thẳng

Right-click on an empty part of the Excel Ribbon, and click Customize the Ribbon In the list at the right, you should only see one tab named Developer If there is a second one, named Developer (Custom), uncheck that tab Then, close the Customize window, and close and restart Excel.

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 hướng dẫn 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:

Record or create one or more macros in the file On the Excel Ribbon, click the File tab, and click Save As Click the Browse button, to open the Save As window (stay in the selected folder) At the bottom, type a File Name In the Save As Type drop down, select Excel Add-In (*.xlam) The AddIns folder should be automatically selected Click Save, then close Excel

Remove an Add-in

To remove an Excel add-in that you stored in the Addins folder, follow these steps.

Xem thêm: Tìm Nghiệm Của Phương Trình Mũ, Bất Phương Trình Mũ Và Bài Tập Áp Dụng

A) Open the Add-ins Window

Use one of these methods to open the Add-ins window:

If the Developer tab is showing on your Excel Ribbon, click that, then click the Excel Add-ins command.

OR, click the File tab, then click Options, and click the Add-Ins category. At the bottom of the window, in the Manage drop down list, choose Excel Add-ins, and then click Go

B) Inactivate the Add-in

Next follow these steps to inactivate the add-in:

In the Add-Ins available list, click on the add-in that you want to inactivate — its description will appear below the list. Read that, to make sure that it”s the add-in that you want to remove Then, remove the check mark beside the Add-in”s name

Next, click OK, to close the Add-ins window. C) Remove the Add-in

Next follow these steps to remove the add-in file:

Close Excel Delete the add-in file, or move it to a different folder, so it won”t open automatically, when Excel starts. Restart Excel, and the add-in will no longer appear.