Enabling Office Integration in Microsoft Excel and Microsoft Word

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

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

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

    See Knowledge Base Article 2064499.

  • An installed, running, and accessible Infor EPM with Office Integration Service as part of the running farm.
  • Client machine running Office Integration requires an 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 and Word.
  • https is required for data retrieval.
  • OLAP and Microsoft Analysis Services are supported as data sources.
  • For client access, the API Gateway or ION API gateway is used which runs on port 443.
  • An installed Microsoft Edge WebView2.

    See Knowledge Base Article 2223874.

A manifest file is required to insert the Office Integration add-in into Microsoft Excel and Microsoft Word. The manifest file is an XML file containing information for Microsoft Excel and Microsoft Word 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. In Windows, use a shared folder, where you copy the downloaded manifest file. If you use Mac, save the downloaded manifest file in these locations: Microsoft Office 365/Microsoft 365 App for Windows or macOS and the required components.
    • For Word: /Users/<username>/Library/Containers/Microsoft Word/Data/Documents/wef
    • For Excel: /Users/<username>/Library/Containers/Microsoft Excel/Data/Documents/wef
    Then, add the manifest manually to Microsoft Excel or Microsoft Word.
    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 and Microsoft Word 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 and Microsoft Word, on the Home tab, click Show Taskpane.
    Microsoft Office 365/Microsoft 365 App for Windows or macOS and 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.