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

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.

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 “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 the “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

• BizTalk 2013 Installation and Configuration – Important considerations before set up the server (Part 1)
• BizTalk 2013 Installation and Configuration – Enable Internet Information Services (Part 2)
• BizTalk 2013 Installation and Configuration – Install Windows Identity Foundation (Part 3)
• BizTalk 2013 Installation and Configuration – Install and configure SMTP Server Feature (Part 4)
• BizTalk 2013 Installation and Configuration – Install Visual Studio 2012 (Part 6)
• BizTalk 2013 Installation and Configuration – Install SQL Server 2012 (Part 7)
• BizTalk 2013 Installation and Configuration – Configure SQL Server Database Mail feature (Part 8)
• BizTalk 2013 Installation and Configuration – Install and Configure BizTalk Server 2013 (Part 9)
• BizTalk 2013 Installation and Configuration – Configure SQL Server Network Configuration protocols (Part 10)
• BizTalk 2013 Installation and Configuration – Validate Mail account used by BizTalk to send BAM Alerts (Part 11)
• BizTalk 2013 Installation and Configuration – Installing BizTalk Adapter Pack (Part 12)
• BizTalk 2013 Installation and Configuration – Install and Configure Microsoft UDDI Services (Part 13)
• BizTalk 2013 Installation and Configuration – Install and Configure the Microsoft BizTalk ESB Toolkit (Part 14)
• BizTalk 2013 Installation and Configuration – Configure BizTalk Server SQL Jobs (Part 15)
• BizTalk 2013 Installation and Configuration – Configure BizTalk Server Windows Services (Part 16)

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. View all posts by Sandro Pereira