Deploying Office Integration manually to a 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 and Microsoft Word, 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, the URL is https://[servername]:[port]. If you are not using SSL, the URL is http://[servername]:[port].
    The default port for http and for https is 9205.
  2. Select 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\.
    Note: Instead of step 6, Mac users must perform these steps:
    1. In the menu bar, select Go > Go to Folder and specify Users/<username>/Library/Constrainers/Microsoft Excel/Data/Documents/ for Excel or Users/<username>/Library/Constrainers/Microsoft Word/Data/Documents/ for Word.
    2. Click Go and search for the wef folder. If the wef folder does not exist, create it.
    3. Paste the add-in manifest file to the wef folder.
  7. Open Microsoft Excel or Microsoft Word.
  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.
    If you switch between manifest files, we recommend that you place only one manifest file per folder and then add your folders to the add-in catalogs.
  12. In the Trusted Catalogs, in the Show in Menu column, select the check box of the manifest file to use in the add-in catalog.
  13. Click OK.
  14. Close all Microsoft Office applications and clear the Office cache.
    See https://docs.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache.
  15. Restart Microsoft Excel and open a worksheet or restart Microsoft Word and open a document.
  16. 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 and the Word document. 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.