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

ArcGIS Maps for Office automatically detects tables and named ranges in the workbook for use in the Add data from my spreadsheet wizard. If there are no tables or named ranges in the workbook, you can manually specify the range of cells to use with the Add data wizard. If your spreadsheet contains a table or named range, the Add data from my spreadsheet window automatically sets that as the current selection.

It is highly recommended that you convert data to a table before adding it to a map. To create a table, click the Insert tab on the ribbon and click Table. Choose the range that contains your data and click OK. Now the locations in this table can be added to a map using the Add Data button from the ArcGIS Maps tab.

If you are unsure as to whether your workbook contains tables or named ranges, use Name Manager on the Excel Formulas tab to see a list of tables and named ranges.

PivotTables are a special type of table in Excel that are used to summarize and analyze data. When adding data, ArcGIS 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 Data wizard if it contains an unsupported data type, has a hierarchy, or has more than one row label.