PTS Blog

Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Utilities

PTS Waterfall Chart Utility
PTS Cluster-Stack Column Chart Utility
PTS Box and Whisker Chart Utility
PTS Marimekko Chart Utility
PTS Dot Plot Utility
PTS Cascade Chart Utility

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the whole blog has been helpful, support further development by treating me to a cup of coffee.


Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Installing an Add-In in Excel 2007

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

In Installing an Excel Add-In I described the protocol for installing an add-in in Excel. The protocol I described was valid for Excel 97 through 2003, but the change in user interface which came with Excel 2007 was accompanied by a more tortuous protocol. It’s not really more complicated once you get used to it, but the first few times it’s an adventure.

To install an Excel 2007 add-in, click on the Office Button, the big round decoration in the top left of the Excel window.

Office Button

This opens the Office Menu. Click the Excel Options button at the bottom of this menu.

Office Menu

The Excel Options dialog opens up. Click the Add-Ins item in the list along the left edge of the dialog to see the Add-Ins panel.

Excel Options: Add-Ins

Make sure the Manage dropdown at the bottom shows Excel Add-Ins, then press the Go button. Finally this brings up the familiar Add-Ins dialog.

Excel Add-Ins Dialog

If the add-in has been stored in one of the default add-in directories, it will appear in the list. Check the box in front of a listed add-in to install it, or uncheck the box to uninstall it. If the add-in does not appear in the list, click Browse, and use the Browse dialog to locate the add-in file.

This long protocol can be shortened in a couple of ways. One way is to add the Add-Ins command to the Quick Access Toolbar (QAT). Click the little dropdown button to the right of the QAT, and choose More Commands.

Customize QAT

Click on the left hand dropdown, and choose All Commands.

Customize QAT

Scroll down, select Add-Ins, and click the Add button.

Customize QAT

Press OK and the Add-Ins button appears on the QAT. It doesn’t look like much, just a greenish round button, but if you mouse over it, you can see the Add-Ins tooltip.

Customized QAT

If you remember the Excel 2003 accelerator keys, you know an easy way to open the dialog. Excel 2007 honors Excel 2003’s Alt-key menu shortcuts. In Excel 2003, you would hold Alt and press T for the Tools menu, then I for the Add-Ins command. In Excel 2007, therefore, you can hold Alt and press T then I (Alt-T-I) to quickly open this dialog.

Possibly Related Posts:

Bookmark and share this entry:
  • Digg
  • del.icio.us
  • Facebook
  • Technorati
  • Twitter
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • LinkedIn
  • Yahoo! Buzz

Learn how to create Excel dashboards.

Comments


Comment from Tim Mayes
Time: Thursday, August 21, 2008, 1:53 am

Jon, what this that Excel icon that is sitting just to the left of the Home tab? This is the first time that I can recall seeing that.

While I’m here, what are those three add-ins that you have obscured in the picture. I’m guessing some kind of top-secret “Excel 2003 Charting Tools” add-in that you are developing to get around the new charting engine. :-)


Comment from Jon Peltier
Time: Thursday, August 21, 2008, 8:53 am

If you have the Show All Windows in Taskbar option unchecked (Office menu > Excel Options > Advanced > Display), this icon appears when a workbook is open and maximized. It essentially serves as the icon on the top left of the workbook’s title bar when the workbook window is maximized.

IMO the Show All Windows in Taskbar option should always be turned off. Why clutter the taskbar with a dozen Excel icons? One is enough.

And the obscured items in the add-ins list are utilities I’ve developed for clients. There’s nothing else really top secret in the works. Enhancements to existing utilities,which so far are still free, and one or two new things, including a really cool error bar utility that gets around how bad the Excel 2007 UI is for adding them (and it also improves a bit on Excel 2003).


Comment from Tim Mayes
Time: Thursday, August 21, 2008, 12:31 pm

Interesting. I hate not having all windows showing in the Taskbar, so I leave that option checked. Typically, I will have at most 3 workbooks opened at once and I tend not to run more than 3 or 4 applications at a time. So, it works for me. I can see the advantage when you have lots of workbooks open.


Pingback from Excel links of the week – weekend without wire [Aug 26] | Pointy Haired Dilbert – Chandoo.org
Time: Tuesday, August 26, 2008, 11:45 am

[...] How to Install add-in : Microsoft Excel 2007 [...]


Comment from AdamV
Time: Tuesday, August 26, 2008, 7:25 pm

“Excel 2007 honors Excel 2003’s Alt-key menu shortcuts”

Well, most of them.
Some are broken in all Office 2007 suite, not just Excel.
Annoyingly, ALT-F-V (print preview) is gone, and ALT-F-I goes to options instead of document properties. I use these two a lot and keep getting the wrong thing. Grrr…
Must retrain fingers to do strange contortions (ALT-F-W-V, or F-E-P respectively)


Comment from Anonymous
Time: Monday, January 5, 2009, 3:09 am

thanks!


Comment from Dave
Time: Tuesday, January 20, 2009, 10:24 am

Can I get the ability do make control charts with an add in or do I have to have SPC Excel?


Comment from Jon Peltier
Time: Tuesday, January 20, 2009, 11:46 am

SPC For Excel has much broader capabilities than simply making control charts. It handles a wide range of statistical processing.

However, for making simple control charts, you can use plain old Excel line charts, as I’ve descibed on my web site in Run Chart with Mean and Standard Deviation Lines and on this blog in Introducing Control Charts (Run Charts) and Use a Chart to See Patterns in Your Data.


Comment from Ross Culver
Time: Monday, March 2, 2009, 11:57 am

Jon, do you have any information on deploying com addin’s? I have several com addin’s created in Visual Studio 2K5. I’ve created a setup project and installed it on an XP test machine. The setup includes the necessary registry entries and the addin appears in the Com Addin’s list in Excel, but I cannot activate them. I can select them, but after selecting they are not available and reviewing the addins again still shows them to be inactive.

Thanks.

Ross


Comment from Jon Peltier
Time: Monday, March 2, 2009, 12:06 pm

Ross -

I have no experience with creating and deploying COM add-ins. My first steps would be to Google for COM add-ins and VS2005, and see where that gets me.


Comment from LA_Excel
Time: Thursday, March 12, 2009, 4:56 pm

This looks pretty straightforward. Will give it a go. BTW – following the Screen shots is really easy .


Comment from Jon Peltier
Time: Thursday, March 12, 2009, 5:12 pm

A screen shot is worth a thousand words.


Comment from hp
Time: Tuesday, March 24, 2009, 10:08 am

thanks a lot..it helped a lot!.


Comment from Diana
Time: Monday, May 18, 2009, 7:38 am

Thank you so much! I am so grateful for this information…saved me oodles of time while working toward a project deadline!


Comment from Mak
Time: Sunday, July 12, 2009, 8:55 pm

G’day John!

Do you have any idea how to add more commands to the Excel 2007 Ribbon. I wanna add a hyperlink to a file.

Cheers
Mak


Comment from Jon Peltier
Time: Sunday, July 12, 2009, 9:24 pm

Mak -

Well, there’s that sad little excuse for a toolbar, called the QAT, stashed up in the title bar. You could try adding your command there. Otherwise you could hack together some XML, which isn’t too hard, but there’s a bit of a learning curve.


Comment from Mak
Time: Monday, July 13, 2009, 7:39 pm

Thanks for the info, Jon.

I got another problem I believe.
I wanna merge columns I to M into N, but there are some date and time formats. The excel merges the columns but wont preserve the date and time format. Can you plz help me fixing it?

I J K L M FORMULA
2009-5-14 T 00:00:00 + 00:00:00 39947T0+0

FORMULA at N7=(I7&”"&J7&”"&K7&”"&L7&”"&M7)

Thanks,
Mak


Comment from Mak
Time: Monday, July 13, 2009, 7:54 pm

OMG – I got thet just sorted out from a forum thread on Microsoft.

I needa use TEXT formula to do the things.

Thanks anyways.


Comment from Jon Peltier
Time: Monday, July 13, 2009, 8:35 pm

The SEND button is a wonderful teacher, isn’t it?


Comment from MS Project Training
Time: Wednesday, August 19, 2009, 7:31 am

After 30 minutes of trying various options in the new interface your page has just saved me looking silly in the face of a delegate’s question! Hehe. Many thanks.


Comment from Anthony
Time: Wednesday, September 16, 2009, 11:20 pm

I can’t say how much this shortcut add-in has helped optimize my data analysis — in my field error bars are a necessity. Things were so much easier in Office 2003 – but this shortcut makes adapting to Office 2007 SO much easier for me.

Thanks for taking the time, I truly appreciate your work.

ajp


Comment from kim
Time: Wednesday, September 23, 2009, 2:24 pm

Hi there,
Does anyone know how to add-in ASAP utilities as one of the tab on the tool bar? When I first downloaded it, it showed up on a blank worksheet. After I close this blank worksheet, it just disappeared. It shows up in the add-in, but when I clicked and “OK” it didn’t do anything. :( ;(


Comment from Jon Peltier
Time: Wednesday, September 23, 2009, 3:29 pm

Kim – Did you run the setup.exe file? This should install all the commands in the appropriate tab/menu configuration.


Comment from kim
Time: Wednesday, September 23, 2009, 3:35 pm

Hi Jon,
Thanks so much for your advice. I called my IT guy, don’t know what he did but he fixed it.

While waiting for my IT guy, I found a different approach for sort by color in Exel 07.

What do you think of the Custom sort/Sort by cell color?


Comment from Jon Peltier
Time: Wednesday, September 23, 2009, 7:02 pm

Kim – I know Excel 2007 introduced the ability to sort by various formatting, but I haven’t used it yet.


Comment from kim
Time: Wednesday, September 23, 2009, 7:18 pm

Oh yeah, Jon, I had no ideas how easy it is to use Custom Sort/Sort by Cell color in Excel 2007. For 200, I guess there’s no other way around it but using ASAP Utilities or similar custom function.


Comment from Teresa Johnson
Time: Saturday, October 24, 2009, 3:06 am

I’m having a problem downloading an Add-In for Excel. I put my disc in and click on the Add-In, it downloads to Programs but it is not in the upper left hand corner of my Excel spreadsheet when I open it. I have even done a search for it and it says it isn’t anywhere on my computer. I have even looked in the Add-Ins. What am I doing wrong?


Comment from Jon Peltier
Time: Saturday, October 24, 2009, 9:30 am

Teresa -

What is the add-in? What is the name of the file in Programs? Is it an exe file that needs to be executed?

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

PTS Waterfall Chart Utility PTS Cluster-Stack Column Chart Utility PTS Box and Whisker Chart Utility PTS Marimekko Chart Utility PTS Dot Plot Utility PTS Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.