Deploying Office Integration manually to local computer folder

When you cannot use a centrally shared location, for example because of the network issues, then you can download the manifest file to a local computer.

Caution: 
In this situation, collaborating on reports might lead to unexpected issues, for example showing multiple add-in panes in Microsoft Excel or add-in errors. To avoid these issues, ensure that all users create and use the same location and that they use local host in the add-in catalog URL.
  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 folder that is the same for all users, for example: C:\Manifest\.
  7. Open Microsoft Excel.
  8. Select File > Options and click Trust Center.
  9. Click Trust Center Settings and click Trusted Add-in Catalogs.
  10. Paste the network path into the Catalog Url field, for example: \\localhost\c$\Manifest.
  11. Click Add catalog.
  12. Select the check box in the Show in Menu column of the new line in the Trusted Catalogs table.
  13. Click OK.
  14. Restart Microsoft Excel and open a worksheet.
  15. 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.