Sponsored Link

There was an error in this gadget

Sponsored Link

Wednesday, January 28, 2009

Install add-ins

Add-ins are basically xla(MS Office 2003) and xlam(MS Office  2007) with built in user define functions or macros.  Add-ins can be created by recording macro or writing macro/function in MS Excel workbook and save the workbook using Save as option.  When you click on save as option, you will find xla option under ‘Save as type’ drop down.  Once you click on xla or xlam option you will find that this file automatically saves in an add-in folder which is located under following path.

C:\Documents and Settings\<>\Application Data\Microsoft\AddIns

So, in case if you receive or download any add-ins then you should follow the steps below to install add-ins on your computer.  For example I have enclosed the add-ins n2t which has function to convert numeric to text (123 – One Hundred and twenty three)

For MS Office 2003
  1. Copy the add-in in the following folder
  2. C:\Documents and Settings\<>\Application Data\Microsoft\AddIns
  3. Open  MS Excel, click on tools and click on add-ins 
  4. Check the box adjacent to N2t.
  5. After you install follow the steps to check if add-ins installed properly.
  6. Type =n2t(A1) in the B1 cell and type 123 in A1. N2t will return  One Hundred and twenty three

For MS Office 2007
  1. Copy the add-in in the following folder
  2. C:\Documents and Settings\<>\Application Data\Microsoft\AddIns
  3. Click on MS Office icon on the top right hand side corner. 
  4. Click on Excel options button
  5. Select the add-ins  and click on Go button at the bottom
  6. Check the box adjacent to N2t.
  7. After you install follow the steps to check if add-ins installed properly.
  8. Type =n2t(A1) in the B1 cell and type 123 in A1. N2t will return  One Hundred and twenty three
For practice, please click on link below to download sample add-in. 




1 comments:

Bart said...

Hello,

I installed the Add-in on 2 pc's and it works fine on both pc's. However, if I make an excel file which uses the n2t()-function on the first pc and I open the excel-file on the other pc, I get the error message: "This workbook contains links to other data sources. If you update the links ..."

Do you know a solution for this problem?

Bart

Post a Comment