- I installed ArcGIS Maps for Office, but the ArcGIS Maps tab does not show on the ribbon.
- Why can't I connect to my ArcGIS Enterprise portal 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 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.
- On the COM Add-ins dialog box, check the ArcGIS Maps for Office check box and click OK.
The ArcGIS Maps tab now appears on the ribbon.
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 for Office configuration settings uses the HTTPS protocol (for example, https://sampleportal.xyz.com/portal). ArcGIS Maps for Office does not support HTTP.
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 Languages option, choose the language you want to use, and click Set as Default.
- After you change the default display language, restart Microsoft Office.
ArcGIS Maps for Office uses the proxy that's defined in the Internet Explorer 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.
To use ArcGIS Maps for Office, you must have an ArcGIS user type that includes privileges to create, analyze, and share content in an ArcGIS Online organization or an on-premises ArcGIS Enterprise deployment. You can sign up for a free trial subscription of ArcGIS Online. It is assumed that the authentication method used to access the platform has been properly configured by the ArcGIS administrator. Public ArcGIS Online accounts are not supported.
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 your spreadsheet. For more information, see Understand credits.
When you use the geocoding or data enrichment features in ArcGIS Maps for Office, you're 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, click the Show credits button on the Add data summary pane to view the number of credits that will be charged to your account.
A credit summary pane appears, listing the total records selected and the number of credits required.
When you enrich your data, the estimated number of credits appears in the last pane of the Enrich layer wizard. Click Show credits to view the number of credits that will be charged to your account.
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 as a member of an ArcGIS Online organization or an ArcGIS Enterprise deployment with privileges to create, analyze, and share content—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 privileges 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 and view pop-up information. Only publicly shared ArcGIS layers and layers created from the Excel spreadsheet will be visible. Map tools will not be available. Your colleagues must sign in with a user type that has privileges to create, analyze, and share to view and interact with all map content.
- Add-in is not installed—A static image of the map will be shown for any 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. 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 non-native data type or has a hierarchy or more than one row label, the Add data from Excel wizard will not recognize it. Non-native data types are typically generated by third-party Excel plug-ins and do not directly conform to normal data types stored in a relational data management system (RDBMS).