This is an archive related to a previous version of ArcGIS Maps for Office. If you need the current version go to http://doc.arcgis.com/en/maps-for-office/.

Work with Portal for ArcGIS

Portal for ArcGIS is a repository for location-based data on your organization's network. Portal for ArcGIS 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 Portal for ArcGIS in much the same way that it does with ArcGIS Online, although some features are not available on the portal.

To start working with Portal for ArcGIS in your organization, you need to do the following:

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

Host the JavaScript files

To use ArcGIS Maps for Office with Portal for ArcGIS in your organization, you need to host the files required by ArcGIS Maps for Office on your network.

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

Portal for ArcGIS 10.3 and 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 Portal for ArcGIS. This is the recommended method to use when possible.

  1. Download the ArcGIS Maps for Office Resources installer, ArcGIS Maps for Office Resources for Portal for ArcGIS 10.3 or higher executable.
  2. Run the installer on the Windows computer hosting your organization's Portal for ArcGIS 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.

Portal for ArcGIS 10.3 and 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.

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

  1. Download the ArcGIS Maps for Office Resources for Portal for ArcGIS 10.2.2 or prior 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/esrimapsforoffice/
    

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

Other Portal for ArcGIS configurations

For all other portal configurations (Portal for ArcGIS versions 10.2.2 or earlier, or operating systems other than Windows), 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.

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 for Portal for ArcGIS 10.2.2 or prior 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="http://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.

  8. Set your set your ArcGIS connection.

Set your ArcGIS connection

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

  • Portal for ArcGIS server URL
  • Web adapter name

For example, say your Portal for ArcGIS is https://myPortal.example.com and your administrator configured your web adaptor to be arcgis. In this case, the URL to your Portal for ArcGIS 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 Portal for ArcGIS administrator.

When you install ArcGIS Maps for Office for the first time, the installation wizard will prompt you to define your connection settings. In the field beside My ArcGIS Portal, provide the URL to your Portal for ArcGIS 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 field, provide the URL to your Portal for ArcGIS instance.

  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.