Good Morning Tracy,
I am sorry to hear about your pain points. Let me attempt to answer your questions and assist below:
Question 1: What am I missing?! This is really plain data!
Potential Answer: I copy/pasted a sample of the data you provided into a workbook and made the data into a table. I was able to add the data successfully using the following parameters:
- Table 1 is the excel data
- I selected the drop-down arrow for Location types and selected 'more location types' to find County Subdivisions
- Styling by County
Question 2: I'm not getting any errors, just something that doesn't load. Are errors being logged somewhere I can lookup?
Potential Answer: I believe this lack of error or not loading has to do with the way the add-in is trying to read the data. Can you attempt my workflow (above) ?
Question 3: (Not all that related to this question) Why are the prompts for updating the version of the add-in so inconsistent?
Potential Answer: I am not sure what your existing workflow is on this part, however, I would say the easiest way is to uninstall Map for Office and reinstall the latest version from here - Download
I'd like to know what the intended workflow is using this data and/or what is the ideal way to add this data (ex. using County or Counts or another variable)? This may help paint a clearer picture so we can determine the best way to proceed.
I look forward to a response.
Have a great weekend!
Best,
Shannon | Product Engineer