Skip To Content

Work with ArcGIS Enterprise

ArcGIS Enterprise is a repository for location-based data on your organization's network. Your ArcGIS Enterprise portal is an alternative to cloud-based hosting and provides access to all your organizational data on-site behind your firewall. ArcGIS Maps for Office works with ArcGIS Enterprise in much the same way that it does with ArcGIS Online, although some features are not available on the portal—specifically those related to an outside Internet connection. For example, a layer showing a live data feed from ArcGIS Online (such as traffic information) will not work on ArcGIS Enterprise because the data requires an active Internet connection. Additionally, if you plan to geocode lines or polygons, you must explicitly configure your ArcGIS Enterprise to do so. For more information, see Configure your own geocode service in the ArcGIS Enterprise help, or watch this video.

To start working with ArcGIS Maps for Office on your ArcGIS Enterprise portal, you need to do the following:

  • Host the resource files required by ArcGIS Maps for Office on your network
  • Set your ArcGIS Maps for Office ArcGIS connection to point to your ArcGIS Enterprise instance

Note:

ArcGIS Maps for Office currently only supports ArcGIS Enterprise configured using HTTPS.

Host the resource files

To use ArcGIS Maps for Office with ArcGIS Enterprise in your organization, you need to host the JavaScript and other resource files required by ArcGIS Maps for Office on your network.

Depending on the version of your ArcGIS Enterprise portal instance and the operating system on which it is installed, there are different ways to do this.

Note:

To have localized ArcGIS Maps for Office help on your portal, you must download and install the Portal Resources for the desired language. To have help available in multiple languages, download and install the Portal Resources for each language.

ArcGIS Enterprise 10.3 or later on Windows

If you're using Portal for ArcGIS 10.3 or later on a Windows server, install Portal Resources for ArcGIS Maps for Office directly on your portal. This is a one-time installation performed on the computer or server hosting your ArcGIS Enterprise portal instance. This is the recommended method to use when possible.

  1. Download the ArcGIS Maps for Office Resources installer, Portal for ArcGIS 10.3 and later (Windows): ArcGIS Maps for Office Resources executable.
  2. Run the installer on the Windows computer hosting your organization's ArcGIS Enterprise portal instance.
  3. Accept all default options to allow the installer to copy the necessary files to your portal.
  4. Set your ArcGIS connection within ArcGIS Maps for Office using the instructions below.

ArcGIS Enterprise 10.3 or later on Linux

If you're using Portal for ArcGIS 10.3 or later on a Linux server, you must manually host the files on the network.

Note:

You must be a system administrator to perform these tasks. You must have the permissions required to modify files on the computer running ArcGIS Maps for Office and the ability to host and make changes to a web server on your network.

To manually host the files on your network, do the following:

  1. Download the ArcGIS Maps for Office Resources installer, Portal for ArcGIS 10.3 and later (Linux): ArcGIS Maps for Office Resources ZIP file and extract the contents.

    The ZIP file contains a folder named office.

  2. On your Portal for ArcGIS machine, browse to the following location:

    portal/<Portal_InstallDir>/webapps/docroot/resources/arcgismapsforoffice/

  3. Create a new subfolder named 5.0.
  4. Copy the office folder from the extracted ZIP file and paste it into the new folder on your portal machine.
  5. Set your ArcGIS connection.

Other Portal for ArcGIS configurations

For all other portal configurations (Portal for ArcGIS 10.2.2 or earlier), you must manually host the files on the network.

This option also requires that you edit configuration files on the ArcGIS Maps for Office client machines.

Note:

You must be a system administrator to perform these tasks. You must have the permissions required to modify files on the computer running ArcGIS Maps for Office and the ability to host and make changes to a web server on your network.

To manually host the files on your network, do the following:

  1. Install and configure a web server such as IIS, Apache, or Tomcat.

    This will be used to host the files needed for use by ArcGIS Maps for Office on your local network.

  2. Download the ArcGIS Maps for Office Resources installer, Portal for ArcGIS 10.2.2 and earlier: ArcGIS Maps for Office Resource ZIP file and extract the contents.
  3. On your web server, create a virtual directory named ArcGISMapsWebRootContents and copy the contents of the extracted ZIP file into it.
  4. On your ArcGIS Maps for Office client machine, open a file explorer and browse to the following location:

    C:\Program Files(x86)\ArcGISMaps\Office

  5. Using a standard text editor, open the following file:

    ESRI.ArcGIS.Mapping.OfficeIntegration.Excel.dll.config

  6. Change the EsriMapsWebRoot value to point to your ArcGISMapsWebRootContents folder on your web server (for example, <add key="EsriMapsWebRoot" value="https://localhost/ArcGISMapsWebRootContents/" />). Save the file and exit the text editor.
  7. Repeat the previous step for the ESRI.ArcGIS.Mapping.OfficeIntegration.PowerPoint.dll.config file located in the same folder.

    Note:

    If a user opens Excel or PowerPoint before you complete the ArcGIS Maps for Office configuration, the changes made to the Program Files(x86) folder won't work. In this case, delete the configuration files from the roaming directory for the user (for example, C:\Users\<username>\AppData\Roaming\ArcGIS Maps). The next time Excel and PowerPoint are started, ArcGIS Maps for Office will detect that the files are missing and copy the correct files into the roaming directory.

  8. Set your ArcGIS connection.

Set your ArcGIS connection

To connect ArcGIS Enterprise to ArcGIS Maps for Office, you need the following information about your portal:

  • ArcGIS Enterprise portal server URL
  • Web adaptor name

For example, say your ArcGIS Enterprise portal server URL is https://myPortal.example.com, and your administrator configured your web adaptor to be arcgis. In this case, the URL to your ArcGIS Enterprise portal would be https://myPortal.example.com/arcgis. By default, the web adaptor for the portal is arcgis, but it can be changed by the administrator for your organization. If you are unsure of what to use as your web adaptor, ask your ArcGIS Enterprise administrator.

Note:

ArcGIS Maps for Office currently only supports ArcGIS Enterprise configured using HTTPS.

When you install ArcGIS Maps for Office for the first time, the installation wizard prompts you to define your connection settings. In the field beside My ArcGIS Portal, provide the URL to your ArcGIS Enterprise portal instance as described above.

To change the ArcGIS Maps for Office configuration, do the following:

  1. Open Microsoft Excel or PowerPoint. Click the File tab on the ribbon to display the Backstage view.
  2. Click ArcGIS Maps.

    The ArcGIS Maps Configuration settings page opens.

    Backstage view for

    By default, ArcGIS Maps for Office uses ArcGIS Online (https://www.arcgis.com).

  3. In the ArcGIS Connection text box, provide the URL to your ArcGIS Enterprise portal instance.

    Note:

    Depending on the security policy within your organization, your web browser may try to block the login page. If the login page is blocked, add the website to the Trusted Sites list in the browser settings.

  4. Restart ArcGIS Maps for Office to apply the changes.
  5. Reopen Excel (or PowerPoint), click the ArcGIS Maps tab on the ribbon, and click Sign In to log in.