PDA

View Full Version : How to install and Addin in Excel 2007 and Excel 2010



Suresh
24-04-2010, 04:00 PM
In response to my earlier post on Suresh Addin (http://www.dq.winsila.com/tips-tricks/an-excel-addin-to-show-currency-in-indian-format-and-words.html), I have received several emails and comments asking for how to install the addin in Excel 2007/2010. The original post only had instructions on how to install the addin in earlier versions of Excel.

So here I describe how to add the Suresh Addin, or for that matter any Excel Addin in the newer versions.

As I only have Office 2010 installed on my computer, I will be using screenshots from that but if I remember right, the process is almost exactly the same in Excel 2007 too.

1. Start up Excel and click on File > Options.

http://www.dq.winsila.com/wp-content/uploads/2010/04/excel2010options_thumb.png (http://www.dq.winsila.com/wp-content/uploads/2010/04/excel2010options.png)

2. In the options window, click on Add-Ins.

3. In the Add-ins options, right at the bottom, you will find the Manage option. Make sure that ‘Excel Add-ins’ is selected in the drop-down box and click on the Go button.

http://www.dq.winsila.com/wp-content/uploads/2010/04/excel2010addins_thumb.png

4. The Add-Ins window that appears is the same as in the older versions of Excel. Click on the Browse button and select the Addin you want to add and click Ok.

http://www.dq.winsila.com/wp-content/uploads/2010/04/excel2010selectaddins_thumb.png (http://www.dq.winsila.com/wp-content/uploads/2010/04/excel2010selectaddins.png)

You can now start using the Addin in your Worksheets.


How to change the default file type for Word 2007 and Excel 2007 (http://www.dq.winsila.com/tips-tricks/ms-office-tips/how-to-change-the-default-file-type-for-word-2007-and-excel-2007.html)
An Excel AddIn to show Currency in Indian format and Words (http://www.dq.winsila.com/tips-tricks/an-excel-addin-to-show-currency-in-indian-format-and-words.html)
How to pin a folder to the task bar in Windows 7 (http://www.dq.winsila.com/tips-tricks/productivity-tips/how-to-pin-a-folder-to-the-task-bar-in-windows-7.html)
Password protect minimized applications with LockThis (http://www.dq.winsila.com/softwares/utilities/password-protect-minimized-applications-with-lockthis.html)
Troubleshooting ‘No Audio’ from the front panel of a desktop computer (http://www.dq.winsila.com/tips-tricks/troubleshooting-no-audio-from-the-front-panel-of-a-desktop-computer.html)

Enjoyed this post? Share it with others. http://www.dq.winsila.com/wp-content/plugins/sociable/images/email_link.png (?subject=How%20to%20install%20and%20Addin%20in%20 Excel%202007%20and%20Excel%202010&body=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html) http://www.dq.winsila.com/wp-content/plugins/sociable/images/printfriendly.png (http://www.printfriendly.com/print?url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&partner=sociable) http://www.dq.winsila.com/wp-content/plugins/sociable/images/digg.png (http://digg.com/submit?phase=2&url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010&bodytext=In%20response%20to%20my%20earlier%20post% 20on%20Suresh%20Addin%2C%20I%20have%20received%20s everal%20emails%20and%20comments%20asking%20for%20 how%20to%20install%20the%20addin%20in%20Excel%2020 07%2F2010.%20The%20original%20post%20only%20had%20 instructions%20on%20how%20to%20install%20the%20add in%20in%20earlier%20versions%20of%20Excel.%20So%20 h) http://www.dq.winsila.com/wp-content/plugins/sociable/images/stumbleupon.png (http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/technorati.png (http://technorati.com/faves?add=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html) http://www.dq.winsila.com/wp-content/plugins/sociable/images/reddit.png (http://reddit.com/submit?url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/delicious.png (http://delicious.com/post?url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010&notes=In%20response%20to%20my%20earlier%20post%20o n%20Suresh%20Addin%2C%20I%20have%20received%20seve ral%20emails%20and%20comments%20asking%20for%20how %20to%20install%20the%20addin%20in%20Excel%202007% 2F2010.%20The%20original%20post%20only%20had%20ins tructions%20on%20how%20to%20install%20the%20addin% 20in%20earlier%20versions%20of%20Excel.%20So%20h) http://www.dq.winsila.com/wp-content/plugins/sociable/images/facebook.png (http://www.facebook.com/share.php?u=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&t=How%20to%20install%20and%20Addin%20in%20Excel%20 2007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/mixx.png (http://www.mixx.com/submit?page_url=http%3A%2F%2Fwww.dq.winsila.com%2F tips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/googlebookmark.png (http://www.google.com/bookmarks/mark?op=edit&bkmk=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010&annotation=In%20response%20to%20my%20earlier%20pos t%20on%20Suresh%20Addin%2C%20I%20have%20received%2 0several%20emails%20and%20comments%20asking%20for% 20how%20to%20install%20the%20addin%20in%20Excel%20 2007%2F2010.%20The%20original%20post%20only%20had% 20instructions%20on%20how%20to%20install%20the%20a ddin%20in%20earlier%20versions%20of%20Excel.%20So% 20h) http://www.dq.winsila.com/wp-content/plugins/sociable/images/friendfeed.png (http://www.friendfeed.com/share?title=How%20to%20install%20and%20Addin%20in% 20Excel%202007%20and%20Excel%202010&link=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html) http://www.dq.winsila.com/wp-content/plugins/sociable/images/blinklist.png (http://www.blinklist.com/index.php?Action=Blink/addblink.php&Url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&Title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/diigo.png (http://www.diigo.com/post?url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/linkedin.png (http://www.linkedin.com/shareArticle?mini=true&url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&title=How%20to%20install%20and%20Addin%20in%20Exce l%202007%20and%20Excel%202010&source=Digital+Quest+Tech+News%2C+Software+Reviews %2C+Tips+%26amp%3B+Tricks+%26amp%3B+more...&summary=In%20response%20to%20my%20earlier%20post%2 0on%20Suresh%20Addin%2C%20I%20have%20received%20se veral%20emails%20and%20comments%20asking%20for%20h ow%20to%20install%20the%20addin%20in%20Excel%20200 7%2F2010.%20The%20original%20post%20only%20had%20i nstructions%20on%20how%20to%20install%20the%20addi n%20in%20earlier%20versions%20of%20Excel.%20So%20h ) http://www.dq.winsila.com/wp-content/plugins/sociable/images/propeller.png (http://www.propeller.com/submit/?url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html) http://www.dq.winsila.com/wp-content/plugins/sociable/images/indianpad.png (http://www.indianpad.com/submit.php?url=http%3A%2F%2Fwww.dq.winsila.com%2Ft ips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html) http://www.dq.winsila.com/wp-content/plugins/sociable/images/myspace.png (http://www.myspace.com/Modules/PostTo/Pages/?u=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html&t=How%20to%20install%20and%20Addin%20in%20Excel%20 2007%20and%20Excel%202010) http://www.dq.winsila.com/wp-content/plugins/sociable/images/slashdot.png (http://slashdot.org/bookmark.pl?title=How%20to%20install%20and%20Addin %20in%20Excel%202007%20and%20Excel%202010&url=http%3A%2F%2Fwww.dq.winsila.com%2Ftips-tricks%2Fms-office-tips%2Fhow-to-install-and-addin-in-excel-2007-and-excel-2010.html)



More... (http://www.dq.winsila.com/tips-tricks/ms-office-tips/how-to-install-and-addin-in-excel-2007-and-excel-2010.html)