Enabling the BAM Excel Add-In for Excel 2007

Earlier versions of Office 2007 are quite different with regard to the layout of the menu and some options may be hard to find in the beginning. Add-In is one of these options.

For enabling the BizTalk Server 2006 BAM Add-In for Excel 2007 (assuming that BAM and Excel are already installed), we need to add it to the ribbon so we can access it. We do that by:

• Going to More Commands… option:

• This will open the Excel option’s dialog box and from there you can select Add-Ins. You should select Business Activity Monitoring in the list:

• Do not exit from Excel Option box…
  After select Business Activity Monitoring, select Manage: Excel Add-Ins, and press Go…, this will bring up a familiar dialog where you need to check the Business Activity Monitoring Add-In.

• Press OK

Having done this the BAM Add-In will now be accessible through the ribbon and you can edit your BAM Activities and Views.

Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community. View all posts by Sandro Pereira