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/.
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:
You should now see the ArcGIS Maps tab on the Ribbon.
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:
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.
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.
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.
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.
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:
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.
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.
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.
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.