Managing Excel Add-ins

Aug 3rd 2012
Share this content

By David H. Ringstrom, CPA

Many programs interface indirectly with Microsoft Excel, but some offer built-in functionality that you may not need or want. In other cases, an add-in that you rely on may suddenly vanish from Excel. In this article I'll explain how you can manage these features.

Excel has long offered the ability for add-ins. For instance, Adobe Acrobat often helpfully adds a separate toolbar or ribbon tab. However, Excel 2007 and 2010 offer built-in PDF printing capability, so do you really need another handful of commands to create PDFs? Certain versions of Sage 50 (formerly Peachtree Accounting) and QuickBooks add extra ribbon tabs to Excel as well. This is great if you need these tools, but unwanted add-ins can cause Excel to take longer to launch, plus your Excel interface can become unwieldy, as shown in Figure 1.

Figure 1: Add-ins sometimes add extra menu commands to Excel's user interface

Here's how to manage add-ins in Excel 2010:

  1. As shown in Figure 2, click on File, Options, and then Add-ins.
  2. Click the drop-down at the bottom and choose COM Add-ins, and then click Go.
  3. Enable or disable add-ins as needed, and then click OK as needed.

The aforementioned steps should handle most add-ins that surreptitiously appear in Excel, but another place to check is the Excel Add-ins list in step 2 above.

The steps are the same for Excel 2007, except you'll click the Office button in the top left-hand corner, and then choose Excel options. From there, follow steps 3 through 9 in Figure 2. In Excel 2003 and earlier, click the Tools menu, choose Add-ins, and then make your selections.

Figure 2: Managing add-ins in Excel

From time to time, an add-in that you rely on may vanish from the Excel user interface or not function correctly. If Excel deems that the add-in has caused an issue, it will automatically place the add-in on a hidden disabled list. To determine if any add-ins have been disabled in Excel 2007 or 2010, follow steps 1 through 4 in Figure 2, and then choose Disabled Items in step 5. As shown in Figure 3, a prompt will appear from which you can enable any add-ins if necessary. In Excel 2003, click Help, About Microsoft Excel, and then click the Disabled Items button.

Figure 3: A hidden Disabled Items prompt allows you to restore an add-in's functionality

See all articles by David Ringstrom

About the author:

David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at [email protected] or follow him on Twitter. David also presents monthly Excel webcasts for AccountingWEB partner CPE Link.

Replies (2)

Please login or register to join the discussion.

By Tom
Jun 25th 2015 20:11 EDT

Thanks for the well-done and helpful post, David

Thanks (0)
By Ashraf Wajid
Jun 25th 2015 20:11 EDT

Mr.David Ringstrom Hi I am leaving in Karachi and doing accounts work in construction firm I have no available any free excel accounting software and also no any tip of MS excel how create accounting system in excel kindly give any free easy excel base accounting software & tip.

Thanks (0)