Problem: The Query option for stand-alone tables in the Format Table Frame pane is inactive in ArcGIS Pro
The Query option is inactive when a stand-alone table is selected from the Table drop-down list in the Format Table Frame pane. Therefore, rows from the stand-alone table cannot be updated dynamically in the Table Frame based on a map series, as the 'Map series rows' option from the Query drop-down list is unavailable.
This is a known limitation, as stand-alone tables are not visible in the map extent. Refer to ArcGIS Pro: Modify a table frame for more information.
Solution or Workaround
A workaround is to create a spatial join between the stand-alone table and an index feature class within the map extent to add the required rows from the stand-alone table to the feature class attribute table. Refer to How To: Join an Excel spreadsheet to a feature class in ArcGIS Pro for steps to do this.
These rows can be queried as a map series when the feature class attribute table is selected from the Table drop-down list in the Format Table Frame pane.
- ArcGIS Pro: Clip layers in a map
- ArcGIS Pro: Create a map series
- ArcGIS Pro: Map series
- ArcGIS Pro: Work with a table frame
Last Published: 5/20/2020
Article ID: 000022754