BizTalk 2013 Installation and Configuration – Install Microsoft Office Excel 2013 (Part 5)

BizTalk
  • Sandro Pereira
  • May 12, 2013
  • 3 min read
Tags: BizTalk, BizTalk Server 2013, Configuration, Installation

Microsoft Office Excel is required for using the Business Activity Monitoring (BAM) feature in BizTalk Server. You use the BAM Office Excel Workbook to define the business processes you want to monitor. You also use the BAM Excel Workbook to define the way in which business users see the data collected by BAM.

Note: BizTalk Server 2013 only supports the 32-bit version of Microsoft Office.

The following procedure installs only Microsoft Office Excel. You can install additional Microsoft Office system applications and tools if you wish, but they are not necessary to complete the installation of BizTalk Server.

📝 One-Minute Brief

To use Business Activity Monitoring (BAM) in BizTalk Server 2013, installing Microsoft Excel is mandatory. This guide explains why the 32-bit version of Excel 2013 is required for the BAM Add-in to function correctly and provides a streamlined installation walkthrough. It ensures your environment is prepared for business analysts to define activities and views using the BAM Excel workbook.

Note: To successfully load BAM.xla into Excel, install the “Visual Basic for Applications” option under “Office Shared Features”. Otherwise, you may get the error “This workbook has lost its VBA project, ActiveX controls, and any other programmability-related features.”

To install Microsoft Office Excel:

  • Insert the Microsoft Office installation disk into the DVD-ROM drive.
  • On the Read the Microsoft Software License Terms screen, select I accept the terms of this agreement and click Continue.
BizTalk Server 2013 office 2013 Read Microsoft Software License Terms
  • On the Type of Installation screen, select Custom Install, and then click Next.
BizTalk Server 2013 office 2013 Type Installation
  • On the Custom Setup screen, ensure that:
    • Microsoft Excel option is selected.
    • And the Visual Basic for Applications option under Office Shared Features is selected.
BizTalk Server 2013 office 2013 Custom Setup
BizTalk Server 2013 office 2013 Custom Setup Office Shared Features
  • And then click Install Now.
  • On the Setup Completed screen, click Finish.

After installing the office Excel and tools, I like to do a Windows update, but this step is not necessary.

Related links

Hope you find this helpful! If you liked the content or found it useful and would like to support me in writing more, consider buying (or helping to buy) a Star Wars Lego set for my son. 

Thanks for Buying me a coffe
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.

2 thoughts on “BizTalk 2013 Installation and Configuration – Install Microsoft Office Excel 2013 (Part 5)”

  1. Pingback: BizTalk 2013 – Installation & Configuration Guide | Vishal Somaiya's Blog
  2. Pingback: Setting up a BizTalk 2013 Development Server on Windows Azure | dotnetable

Leave a Reply

Your email address will not be published. Required fields are marked *

The Ultimate Cloud
Management Platform for Azure

Supercharge your Azure Cost Saving

Learn More
Turbo360 Widget

Get integration tips every day. Follow us on:

Back to Top