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

Posted: January 8, 2015 in BizTalk
Tags: , , , ,

This next posts will focus on installing the BizTalk prerequisites and perform the necessary configuration on BizTalk Server machine.

Before installing BizTalk Server or its prerequisites, make sure you have installed the latest critical Windows updates from Microsoft.

Install Microsoft Office Excel 2013

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

Important Note: BizTalk Server 2013 R2 supports only 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.

Important Note: To successfully load BAM.xla into Excel, you will need to 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 Read the Microsoft Software License Terms screen, select “I accept the terms of this agreement” and click “Continue”


  • On the Type of Installation screen, select Custom Install, and then click “Next”.


  • On the Custom Setup screen, ensure that:
    • Microsoft Excel option is selected.
    • And “Visual Basic for Applications” option under Office Shared Features is select.



  • 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, this step is not necessary.

Related links

Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s