I have a map with 1 layer. Each polygon has a field 'FIELDFULL'. I have a spreadsheet with tabular data also with a field 'FIELDFULL'. Map comes up fine. When I try to add the Excel data it only has options for the approved list of location fields, no way to select the common column to match the data. I thought on the previous version I was able to join on that field as a custom field. Please advise on how to display the data in the spreadsheet joined on the custom column.
I assume that you have created a custom locator that locates Excel data based on the FIELDFULL field. But when you try to use that locator, the FIELDFULL field in your Excel data is not available? Correct?
Are both of these fields formatted the same? (as in both as text or both as numeric?)