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:
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.