Enable BizTalk BAM Add-in in Excel 2016

Recently I had a project where I needed to use the Microsoft Office Excel BAM add-in. At Codit Belgium, where I work, we have an Office 365 subscription.

I followed the guide Enabling BAM Add-In for Excel 2016, by Sandro Perreira, but was unable to find the BAM Add-in within my Excel installation.

One thing I found, is that the BAM add-in, was not listed as it listed correctly below:

addin_list

Solution

Do the following:

Press the quick access shortcut in the title bar and choose More Commands…

bam_addin_morecommands

Select “Add-ins” in the left menu and click “Go”:

addins_go

Click the Browse button and navigate towards the directory:

C:\Program Files (x86)\Microsoft BizTalk Server 2013 R2\ExcelDir

Select the Bam.xla file there and click OK.

bam_addin_xla

Then, enable the Add-in, click OK and go ahead.

bam_addin_enable

Hope this helps someone.
Cheers!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s