Enabling Office Integration in Microsoft Excel

Follow this procedure to connect Office Integration to Microsoft Excel®.

Office Integration is a web application that is shown inside a task pane of Microsoft Office. The true client is Microsoft Office.

These are the prerequisites for running Office Integration in Microsoft Excel:

  • Microsoft Office 365/Microsoft 365 App for Windows or macOS and the required components.

    See Knowledge Base Article 2064499 on the Infor Support Portal for further information.

  • An installed, running, and accessible Infor d/EPM Platform with Office Integration Service as part of the running farm.
  • Client machine running Office Integration requires Internet connection to access external sites with Office.js API libraries.
  • DOM storage enabled in your browser for the WebView that is used in Excel.
  • https is required for data retrieval.
  • OLAP and Microsoft Analysis Services are supported as data sources.
  • For client access, the ION API gateway is used which runs on port 443.

A manifest file is required to insert the Office Integration add-in into Microsoft Excel. The manifest file is an XML file containing information for Microsoft Excel to find the corresponding add-in web application. For Office Integration, the downloaded profile is the manifest file.

  1. The manifest file can be deployed in one of these ways:
    Option Description
    Manual deployment Use this option in an on-premises environment. You use a shared folder, where you copy the downloaded manifest file. Then, you add the manifest manually to Microsoft Excel.
    Note: To avoid add-in installation errors, you must clear the cache before switching to a different environment.
    Centralized deployment We recommend this deployment type. The Office 365 administrator deploys the manifest through centralized deployment. The administrator downloads the manifest. Then, in the Office 365 admin center, the administrator browses for the manifest file and deploys it to users or user groups within their organization. After centralized deployment, Office Integration is available in Microsoft Excel for the designated users.
    Multi-tenant deployment In multi-tenant environments, you must define the tenant to which you want to connect.
  2. In Microsoft Excel, on the Home tab, click Show Taskpane.
    The time to load the task pane depends on the location where the Office Integration Service runs. It can take some time to load.
  3. If Office Integration is deployed in a multi-tenant environment, specify the tenant name to which you want to connect to.
    The tenant name that you specify is stored and is used until you sign out. After you sign out from Office Integration, the tenant name must be specified again when you sign in. You can select a tenant from the list or specify a new tenant name. You can select from up to ten tenant names that were previously used.
  4. To run Office Integration on the same machine as the farm, enable the loop-back exception.

    See Knowledge Base Article 2111352 on the Infor Support Portal for further information.