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/.
When your data contains addresses that you want to use as your location information, you typically need to pay ArcGIS service credits to geocode the information—that is, to generate spatial coordinates that appear as points on your map. After you've done so, you may want to add columns to your spreadsheet to contain the generated spatial coordinates so that you can reuse the information in other maps or spreadsheets without incurring additional geocoding costs. ArcGIS Maps for Office allows you to easily add new location columns to your spreadsheet, or to replace existing columns with the new location information.
The Add XY coordinates feature applies only to layers that contain point geometries; it is not available for line or polygon layers. Also, this feature is enabled only when a map layer was created using an Excel table; if the layer was created using a named range or a cell range, the feature is not available.
To add new coordinates to your spreadsheet, do the following:
The Insert XY coordinates into worksheet pane opens.
The new spatial information is added to your spreadsheet.