OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Queue Servicing Calculator

Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
PC Tip Microsoft Excel OfficeHelp Free

How to install an Excel AddIns - Version 0.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any Windows version from 2000


 

An Excel AddIn is an extension to Excel and, once installed, will load every time Excel is loaded, becoming “part” of Excel until it is deliberately uninstalled. Learn how to install and manage them on all versions of Excel from 97 to 2007.

This Article Applies to:

This article applies to all Excel® versions since Excel® 97. Excel® 2007, the latest edition released by Microsoft, is compatible with most existing Add-Ins, but will display a completely different interface, so it has a special section on it.

Most of this article will also apply to other Microsoft® Office® applications like Word® or PowerPoint®, but they usually have much less Add-Ins available than Excel®.

What are Add-Ins?

An Excel AddIn is an extension to Excel and, once installed, will load every time Excel is loaded, becoming “part” of Excel until it is deliberately uninstalled. They often add entries to existing menus of even whole menus or toolbars. Add-Ins can also supply additional functions that can be used in cell formulas like the native ones. They have been part of Excel for long and, in fact, Microsoft supplies several Add-Ins with Excel itself, with the most well known being the “Analysis Toolpak” and the “Solver”.

Many Add-Ins are also supplied by Third Party software makers, either to extend Excel native functionality, providing additional functions and features, or to link Excel to data applications, common on corporate networks were Business analysts use Excel to manipulate data from corporate databases like ERPs, Accounting, Business Intelligence suits or other operational systems.

Add-Ins usually have the file extensions .XLA or .XLL. For samples, try searching for “Excel Add-Ins” on any internet search engine. You will find hundreds of them.

How to Install / Uninstall Excel Add-Ins?

Excel® 2007

Excel 2007 Add-Ins are managed from the “Excel Options” button on the “Office Menu” menu:

Select "Add-Ins" on the left side navigation column. Excel will list all available Add-Ins on the right pane window. On the bottom, select Manage: Excel Add-Ins and click "Go".

From here, follow the guidelines below on "All Excel Versions" as this will be common to all.

Excel® 97 to 2003

Excel Add-Ins are managed from the “Add-Ins” entry on the “Tools” menu:

All Excel® Versions

The above menu entries (depending on version) will both open a Pop-Up windows where you can activate / deactivate any AddIn Excel is currently aware of by checking / unchecking its respective checkbox:

Click Cancel to leave the Add-Ins as they were when the Pop-up opened, discarding any changes, or OK to activate the selections made. Activated Add-Ins will be loaded after OK and every time Excel is loaded after that, until selections are changed again.

How to add new Add-Ins to the Add-Ins Available list?

This article will ignore the “Automation” button, as it is used for more technically complex Add-Ins.

There are two ways to add new AddIns to the list:

  1. Saving them to the default Add-Ins folder
  2. Telling Excel where they are using the “Browse” button.

1) Saving them to the default Add-Ins folder:

Excel has, by default, an Add-Ins folder and all Add-Ins saved on it will automatically be listed on the pop-up list. This is the easiest way to do it, but you need to know there the folder is located on your hard disk.

Excel will tell you where it is. Click on the “Browse” button and you will get the regular “file open” dialog box, open by default on the Add-Ins folder:

Open the whole disk path (as on the picture above) to find it. Once you know where it is, open it using the Windows Explorer and save your new Add-In file there.

After you have copied the Add-In file there, close Excel and open it again. Open the Add-Ins window and your file will be there (you will need to know its list name; the file supplier should tell you that).

2) Telling Excel where they are using the “Browse” button.

Instead of finding the default folder and copying the file there, you may instead tell Excel that there is an Add-In somewhere else on the harddisk (or even on a network disk). Click on the “Browse” button, select the folder where the file is located and select it. Click “OK” and the file will be immediately added to the list.

Activating ALL Add-Ins: Why not?

You should not activate all Add-Ins just because they are present and ready to be activated. Add-Ins take time to load and, the more you activate, the longer Excel will take to load. Leave frequent used Add-Ins activated so they are loaded every time, but activate less frequent ones only when necessary, deactivating them again when they are no longer needed.

 



Get FREE PC TIPS every month:

 

How to install an Excel AddIns - Version 0.00

Tested on Microsoft Excel Versions: 2000 (9.0), XP (10.0), 2003 (11.0), 2007 (12.0), 2010 (14.0), 2013, 2016 - should work on any Windows version from 2000


Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz