Deploying Office Integration manually to centrally shared folder

We recommend that the Office Integration manifest file is downloaded to a single, shared folder. All users then reference that folder by adding its URL to their trusted catalogs table in Microsoft Excel. The benefit is that you have a single location to administer.

  1. Open a browser window and specify the URL.
    For SSL protocol, the URL is https://[servername]:[port]. If you are not using the SSL protocol, the URL is http://[servername]:[port].
    The default port for http and for https is 9205.
  2. Select d/EPM Administration and click Open Application.
  3. Select Dashboards > Farm Administration > Client Access.
  4. Click Download Profile for Office Integration.
  5. Click Download.
  6. Copy the manifest file to a dedicated central folder, for example: C:\Manifest\.
  7. Share the Manifest folder on the network.
  8. Right-click the folder and select Properties.
  9. Click the Sharing tab and click Advanced Sharing.
  10. Select the Share this folder check box and click OK.
    Verify that the Network Path field in the Advanced setting dialog box shows the correct path. For example: \\Computer_Name\Manifest.

    Copy and paste the path to the clipboard or write the path down as you must use it later.

    Note: The steps for downloading profile and sharing the manifest file are one time setup. If you already use a shared folder, proceed with the next steps.
  11. Open Microsoft Excel.
  12. Select File > Options and click Trust Center.
  13. Click Trust Center Settings and click Trusted Add-in Catalogs.
  14. Paste the network path into the Catalog Url field, for example: \\Computer_Name\Manifest.
  15. Click Add catalog.
  16. Select the check box in the Show in Menu column of the new line in the Trusted Catalogs table.
  17. Click OK.
  18. Restart Microsoft Excel and open a worksheet.
  19. Select Insert > My Add-ins. On the SHARED FOLDER tab, select the add-in and click Add.
    The add-in is launched at the right side of the Excel worksheet. You can drag the add-in window to another position and re-size it if required.
    Note: If the Shared Folder tab is not available, it has been disabled by an administrator. See “Group Policy Objects for administrators” for details.