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.

Tables and named ranges

Esri Maps for Office automatically detects tables and named ranges in the workbook for use in the Add Excel Data wizard. If there are no tables or named ranges in the workbook, you can manually select your range of cells to use with the Add Excel Data wizard. If there are tables or named ranges, the Add Excel Data dialog box automatically sets that as the current selection.

It is highly recommended that data should be converted to a table before being added to a map. To create a table, click the Insert tab on the ribbon and click Table. Select the range where your data are located and click Ok. Now the locations in this table can be added to a map using the Add Excel Data button from the Esri Maps tab.

If you are unsure as to whether you have tables or named ranges in your workbook, use the Name Manager in Excel (on the Formulas tab) to see a listing of tables and named ranges.

Excel Name Manager dialog box

Pivot tables are special type of table in Excel that are used to summarize and analyze data. When adding data, Esri Maps for Office automatically detects pivot tables for use in the Add Excel Data wizard and includes them if appropriate. A pivot table will not be added to the Add Excel Data wizard if it contains an unsupported data type or has a hierarchy or more than one row label.