Forum Discussion
Geography Heat Map by County issues
That's nothing predefined here. Map Charts is quite sensitive to column names and data organization, as well as places names. That's as with search engine - depends on wording in search bar you may find what you need very fast or never find.
If change data a bit some of your places are shown
Mainly for Alaska. On the other hand not all places in next level administrative divisions
If nothing helps that's only from Help -> Feedback to send a frown, perhaps Microsoft one day checks bing engine algorithm applied to Map Charts and improve it.
SergeiBaklan ...another quick question, but on a similar subject...when I transfer a file with a large quantity of already geo-tagged cells (about 3000 US counties), the user I send the file to only sees #UNKNOWN in those cells, even though they have the correct version of Excel and should be able to open it just fine. is the geotag data linked to a supplemental file on my computer or something??
To my knowledge everything is done on the server, Excel only keeps in cache within current file results of the latest update (refresh). If next update fails for any reason you have an error.
Perhaps that could be due to different locale, e.g. you are on English US and another person on Spanish one.
Here similar issue was discussed, unfortunately without solution Geography data with #UNKNOWN! error - Microsoft Community
Sorry, but I don't know exact answer.
- thanks Sergei for the link to that other post...that is the exact issue I am having...transferring files with a few geotags works fine, but many (3000+ for me) does not work and shows #UNKNOWN.