Frequently asked questions
- I installed ArcGIS Maps for Office, but the ArcGIS Maps tab does not show up on the ribbon.
- Why can't I connect to my Portal for ArcGIS instance from ArcGIS Maps for Office?
- How do I install a Microsoft Office language interface pack?
- How do I set up a proxy PAC file to work with ArcGIS Maps for Office?
- How do I set the language for ArcGIS Maps for Office?
- How do I tell which version of ArcGIS Maps for Office I have installed?
- Do I need an ArcGIS subscription to use ArcGIS Maps for Office?
- Does this app consume ArcGIS credits?
- Does all geocoding consume credits?
- How do I know how many credits I'm using when geocoding or enriching my data?
- Why doesn't my spreadsheet appear in the Add data from Excel wizard?
- I received an error message when signing in to ArcGIS Online.
- If I make a map in Excel, what happens when I send the spreadsheet to my colleagues? Will they see the map?
- My organization has a geocoder registered with ArcGIS. Can I use it with ArcGIS Maps for Office?
- Can I add a custom basemap to the Basemap Gallery in ArcGIS Maps for Office?
- 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?
- Why doesn't my clustered layer display in ArcGIS Online?
- Why doesn't ArcGIS Maps for Office recognize my PivotTable when adding data?
- Why isn't cell formatting preserved when sharing to ArcGIS Online?
- Can I add a Bing basemap to my map?
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:
- Click the File tab on the ribbon to access the Microsoft Office Backstage.
- Click Options to display the PowerPoint Options or Excel Options pane.
- Click Add-Ins and find the ArcGIS Maps for Office add-in. It should be listed under Inactive Application Add-Ins.
- At the bottom of the pane, set the Manage drop-down menu to COM Add-Ins and click Go.
- In the COM Add-ins dialog box, check the ArcGIS Maps for Office box and click OK.
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 set the language as the default display language. To set the default display language in Microsoft Office, complete the following steps:
- Open a Microsoft Office program, such as Excel.
- Click the File tab and click Options.
- In the Excel Options pane, click Language.
- Under the Choose Display and Help Languages heading, choose the display language you want to use, and click Set as Default.
- After you change the default display language, close and restart Microsoft 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.
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.
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.
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.
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 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—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.
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.
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.
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.