Skip To Content

Frequently asked questions

I installed ArcGIS Maps for Office, but the ArcGIS Maps tab does not show up on the ribbon.

Occasionally, the ArcGIS Maps for Office add-in is not enabled by default in Excel or PowerPoint. To fix this issue, manually enable the add-in using the following steps:

  1. Click the File tab on the ribbon to access the Microsoft Office Backstage.
  2. Click Options to display the PowerPoint Options or Excel Options pane.
  3. Click Add-Ins and find the ArcGIS Maps for Office add-in. It should be listed under Inactive Application Add-Ins.
  4. At the bottom of the pane, set the Manage drop-down menu to COM Add-Ins and click Go.
  5. In the COM Add-ins dialog box, check the ArcGIS Maps for Office box and click OK.

    COM Add-ins dialog box

    You should now see the ArcGIS Maps tab on the ribbon.

Why can't I connect to my ArcGIS Enterprise portal instance from ArcGIS Maps for Office?

If you can't connect to your ArcGIS Enterprise portal instance from ArcGIS Maps for Office, ensure that the ArcGIS connection specified in the ArcGIS Maps configuration settings uses the HTTPS protocol (for example, https://sampleportal.xyz.com/portal). ArcGIS Maps for Office does not support HTTP.

How do I install a Microsoft Office language interface pack?

To install ArcGIS Maps for Office in the native operating system (OS) language, you need to first install the Microsoft Office language pack in the desired language, and set the language as the default display language. To set the default display language in Microsoft Office, complete the following steps:

  1. Open a Microsoft Office program, such as Excel.
  2. Click the File tab and click Options.
  3. In the Excel Options pane, click Language.
  4. Under the Choose Display and Help Languages heading, choose the display language you want to use, and click Set as Default.
  5. After you change the default display language, close and restart Microsoft Office.

How do I set up a proxy PAC file to work with ArcGIS Maps for Office?

ArcGIS Maps for Office uses the proxy that's defined in the IE browser settings. With Microsoft IIS (and other web servers), you can use a proxy PAC file to dynamically switch proxy settings when your connection changes (for example, if you move your laptop from your office network to a home-based VPN).

Proxy settings are specific to your web server. For more information, refer to the Microsoft documentation.

How do I set the language for ArcGIS Maps for Office?

ArcGIS Maps for Office uses the language specified in the Excel Options window, not the operating system (OS) culture setting. To set the language in Excel, click the File menu and click Options. In the Options window, choose Language, and specify the language as desired.

How do I tell which version of ArcGIS Maps for Office I have installed?

To see which version of ArcGIS Maps for Office is currently installed, click the File menu and choose ArcGIS Maps. The current version number is listed under the Current User entry.

Do I need an ArcGIS subscription to use ArcGIS Maps for Office?

Yes. ArcGIS Maps for Office users need a level 2 membership in an ArcGIS Online organization or an ArcGIS Enterprise portal instance. Public ArcGIS Online accounts are not supported.

Does this app consume ArcGIS credits?

Some features of ArcGIS Maps for Office consume credits. Credits are most often consumed through address geocoding or data enrichment—functions that add new columns of data to the user's spreadsheet. For more information, see Understand credits.

Does all geocoding consume credits?

Only geocoding using the Esri World Geocoder (the default address option in ArcGIS Maps for Office, U.S. cities, or world cities) consumes geocoding credits. Other options, such as ZIP Codes, states, counties, or countries, are considered standard geographies and do not consume ArcGIS credits.

How do I know how many credits I'm using when geocoding or enriching my data?

When you use the geocoding or data enrichment features in ArcGIS Maps for Office, you'll be presented with the approximate number of credits required to complete the operation. When you choose Address, US City, or World City from the Location Type drop-down list, the estimated number of credits that will be charged to your account appears in the lower left corner of the Add data from my spreadsheet pane.

Estimated service credits for geocoding

The estimated credit consumption also appears on the confirmation pane.

When you enrich your data, the estimated number of credits appears in the Enrich layer pane.

Estimated service credits for data enrichment

Why doesn't my spreadsheet appear in the Add data from Excel wizard?

ArcGIS Maps for Office recognizes tables and named ranges and automatically adds those to the Add data from Excel wizard. If there are no tables or named ranges in your worksheet, you need to manually select a cell range.

I received an error message when signing in to ArcGIS Online.

ArcGIS Maps for Office uses an ArcGIS account that is registered as part of an organization's subscription. You cannot use an ArcGIS Online personal account. If you try to sign in to ArcGIS Online with a personal account, the No ArcGIS subscription message appears. Contact your ArcGIS administrator to gain access to your organization, or sign up for a free trial of ArcGIS Online.

If I make a map in Excel, what happens when I send the spreadsheet to my colleagues? Will they see the map?

What your colleagues see depends on whether they have ArcGIS Maps for Office installed and whether they are signed in to ArcGIS. Here's what your colleagues will see in various scenarios:

  • ArcGIS Maps for Office is installed and the user is signed in to ArcGIS as a level 2 member of an ArcGIS Online organization or an ArcGIS Enterprise deployment—The map will be fully interactive and your colleagues will have the ability to pan and zoom the map, add and remove layers, and work with the tools in the map. They will see the layers they have access to and be able to perform actions that are allowed for the permissions that have been assigned to them. Changes to the spreadsheet will be reflected in the map, and new rows will be geocoded (as long as your colleagues have geocoding permissions within ArcGIS).
  • Add-in is installed but the user is not signed in to ArcGIS—Your colleagues will be able to pan and zoom the map as well as view attribute information in pop-ups for visible layers. Only publicly shared ArcGIS layers and layers created from the Excel spreadsheet will be visible. Map tools will not be available, and generally the map will be in a limited view-only mode. Changes made to spreadsheet data will be reflected in pop-ups, but new rows will not be geocoded until a named user signs in.
  • Add-in is not installed—A static image of the map will be shown for all anchored maps in the spreadsheet. Floating maps (maps are floating by default) will not be shown. To anchor a floating map so an image of it can be seen by everyone, use the arrow control in the upper left corner of the map window.

My organization has a geocoder registered with ArcGIS. Can I use it with ArcGIS Maps for Office?

Yes, you can. When you add data to a map from Excel, click the Location Type drop-down arrow and choose More from the list. You will find your custom geocoder (that has been registered with ArcGIS) at the top of the window that appears.

Can I add a custom basemap to the Basemap Gallery in ArcGIS Maps for Office?

Custom basemaps can be added to the group selected by the ArcGIS administrator as the Basemap Gallery group.

When I add a layer from ArcGIS Online that contains a large number of points, are all the points added to the map at once?

No. When you add a layer to your map from ArcGIS Online, not all points are added to the map at the same time. In an effort to maximize performance, ArcGIS Maps for Office adds feature points in batches, based on the visible map extent. As you zoom or pan across the map, points that will be visible in the new extent are added to the map.

Why doesn't my clustered layer display in ArcGIS Online?

Clustering is not supported in ArcGIS Online, so a layer that is clustered in ArcGIS Maps for Office will display as a point layer in the ArcGIS Online Map Viewer. If you share a map that contains a clustered layer then create a dynamic PowerPoint slide using the shared map, the clustered layer will display as it does in ArcGIS Maps for Office in Excel, with clustering enabled.

Why doesn't ArcGIS Maps for Office recognize my PivotTable when adding data?

When adding data, the Add Data from Excel wizard attempts to recognize tables and named ranges in your spreadsheet. If possible, it will also recognize existing PivotTables in the spreadsheet. If the PivotTable contains an unsupported data type or has a hierarchy or more than one row label, the Add Data wizard will not recognize it.

Why isn't cell formatting preserved when sharing to ArcGIS Online?

Cell formatting, such as double or datetime, may not be preserved in pop-ups when sharing a map or layer to ArcGIS Online. In these cases, ArcGIS Maps for Office publishes the value in the cell, not the formatted string, so that additional analysis can be performed on the value if desired.

Can I add a Bing basemap to my map?

ArcGIS Maps for Office does not provide a user interface to add Bing Maps. Bing Maps basemaps must be configured online by the administrator of your ArcGIS Online organization.