Installing the Excel add-in by using a manifest file

Edit online

If you want to install the add-in at an enterprise level or if your organization has restrictions around installing an add-in, you can manually install the add-in by using a manifest.xml file.

Before you begin

On Windows and Mac, you must have Excel 2019 or later.

About this task

If you have multiple manifest files, save them in separate folders to avoid conflicts.

Procedure

  1. Click manifest.xml to download the file.
    If your browser displays the XML instead of downloading the manifest file, save the page as manifest.xml.
  2. Install the add-in by using the file.
    Platform Steps
    Office 365 - Online
    1. Open Excel, and on the Home tab, click Add-ins > More Add-ins.
    2. Click MY ADD-INS and in the My Add-ins dialog, click Browse and then upload the manifest.xml file.

    A new IBM Envizi Emissions API button appears in the Excel header.
    Windows
    1. Share the folder that contains the manifest file.
      1. Right-click the folder, select Properties, and click the Sharing tab.
      2. Click Share, add users who need access to the add-in, and then note the network path.
    2. Configure trusted add-in catalogs.
      1. In Excel, click File > Options.
      2. In the Excel Options window, from the menu, click Trust Center and then click Trust Center Settings.
      3. In the Trust Center window, from the menu, click Trusted Add-in Catalogs.
      4. In the Catalog URL field, enter the network path that you noted in step a.ii.
      5. Select the Show in Menu checkbox.
      6. Click OK to save your changes and then click OK to close the Excel Options window.
    3. Restart Excel and open the add-in.
      1. Close any Excel windows.
      2. Open Excel and click Insert > Add-ins.
      3. On the SHARED FOLDER tab, select the add-in and click Add.
      4. Sign in using your account credentials. To see your account credentials, in the IBM® Envizi Emissions API user interface, click View API key.
    Mac
    1. Open Finder and from the Finder menu, click Go > Go to Folder.
    2. Enter the following path, changing the username to the name of the Mac user: /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Documents.
    3. Add the manifest.xml file to the wef folder. If the folder does not exist, create it, and then add the manifest.xml file.
    4. Open Excel and click Home > Add-ins.
    5. From the add-ins menu, click IBM Envizi Emissions API.
    For more information about installing add-ins on a Mac, see Sideload Office Add-ins on Mac for testing
  3. In Excel, change the calculation mode to prevent unnecessary API calls:
    1. From the menu, click Formulas > Calculation Options and then select Manual.
    2. Optional: To recalculate a formula in manual calculation mode, press F9 on your keyboard.

What to do next

If you encounter issues when you install the add-in on Windows, see Installation of manifest file in Windows failed.