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:

Solution

Do the following:

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

Select “Add-ins” in the left menu and click “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.

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

Hope this helps someone.
Cheers!