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/.

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 the 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 box beside ArcGIS Maps for Office 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 Portal for ArcGIS instance from ArcGIS Maps for Office?

If you can't connect to your Portal for ArcGIS 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 then set the language as default display language. Set the default display language in Microsoft Office using 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, select the display language that 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 the language for ArcGIS Maps for Office?

ArcGIS Maps for Office uses the language specified in the Excel Options window and 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 named user license for a ArcGIS Online organization or Portal for ArcGIS instance.

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 Service credits overview.

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.

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 on the Enrich layer pane.

Estimate 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 colleague? Will they see the map?

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

  • ArcGIS Maps for Office is installed and user is signed in to ArcGISThe map will be fully interactive and your colleague 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 colleague has geocoding permissions within ArcGIS).
  • Add-in is installed but the user is NOT signed in to ArcGIS—Your colleague 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 that 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 arrow on the Location Type drop-down list and choose More. 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 heat map display in ArcGIS Online?

Heat map layers and layers that are clustered cannot be shared to ArcGIS Online as a layer, but can be shared as part of a map. In the ArcGIS Online viewers (that is, the ArcGIS.com Map Viewer and ArcGIS Explorer Online), the heat map layer displays as a point layer instead of rendering as a heat map. When you create a PowerPoint slide from Excel, the heat map layer displays as it does in Excel.

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 recognized 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 and 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.