Location of Biztalk BAM Excel add-in

I've just started working on a BAM project, so I started reading tutorials. Everyone was mentioning Excel add-in. I thought that it was an installation that you download from Microsoft's website, but after spending couple of hours searching for this add-in I realized it's just a plain Excel file BAM.xls located in \Program Files\Microsoft BizTalk Server 2004\Tracking (depends in which folder you installed BizTalk) that you need to copy somewhere else, because it's read-only. I felt so stupid! I hope I spared you some time looking for it.

Update: In BizTalk 2006 BAM Excel is no longer implemented as a Excel template, now it's a permanent add-in. If it's not available when you open Excel, click Tools -> Add-ins -> Business Activity Monitoring

Share This Post:

posted on Tuesday, January 24, 2006 11:01 AM

Feedback

# re: Location of Biztalk BAM Excel add-in 12/20/2007 9:24 AM David

Definitely just saved me some time. Thank you!

# re: Location of Biztalk BAM Excel add-in 8/13/2008 2:36 PM shweta

yes u did! Thanks a bunch!

# re: Location of Biztalk BAM Excel add-in 11/17/2008 3:27 AM Sven

I tried to find the BAM Excel Add In in my Excel 2007, but couldnt find it. I installed BTS 2006 R2, installed Office 2007, and then reinstalled BTS 2006 R2, but I still cant see any BAM Add-Ins in Excel! Do I need to install Office 2003 to be able to use BAM Add-In?

# re: Location of Biztalk BAM Excel add-in 12/1/2008 2:21 AM Philip

Thanks for your comment. You really help me :).

# re: Location of Biztalk BAM Excel add-in 3/17/2009 2:43 PM Kalyan

Thanks for the Tip. It helped me a lot of time...

# re: Location of Biztalk BAM Excel add-in 6/15/2010 2:46 PM Michael

Check out this posting for better visual details on enabling things in Office 07...

http://blogical.se/blogs/johan/archive/2008/01/19/enable-the-bam-excel-add-in-in-excel-2007.aspx

# re: Location of Biztalk BAM Excel add-in 7/20/2010 11:40 AM WAQAR AHMED

BAM in Biztalk 2009.
Install and configure Bam tools and portal.
Install Office 2007.
In Excel 2007, go to Excel Button and select Excel Options.
In the Addins if Bam is not visible in the list then select Go.. browse button.
Browse to BizTalk Installation Dir\Exceldir and select Bam.xla.
Now the Addin tab will be visible in the Excel with Bam button.

# re: Location of Biztalk BAM Excel add-in 8/4/2010 12:47 AM Digambar Kandangire

with reference to above comment, for BAM add-in in Biztalk 2009, I did NOT have to select .xla file (Office 2007). Just checked the "Business Activity Monitoring" checkbox and clicked OK. It worked just fine.

By the way, I did it that way because I could not find any .xla file in BTS 2009 directory.

# how to export BAM Results to excel 8/16/2010 6:44 AM swati

please reply

# re: Location of Biztalk BAM Excel add-in 8/9/2011 11:17 AM josh

good one.....appretiate it......

Darko Jovisic

News

Archives

Post Categories

Feedback