Forum Discussion
Bing Maps doen't recognize locations
Hi all,
Windows 10 fr, Excel 2016 fr.
Any location is "not found", whether it's towns, countries, postal codes etc. Has anyone the same problem ?
Thanks in advance.
Can you post how you identify locations? Also, how do you connect your Excel data to Bing maps?
Do you get any errors?
- For testing purposes, i'm using the same data shown in the example : https://1drv.ms/i/s!AqRP0RQrhNWWyAmsAuMHDG80dP99 I connect to Bing Maps using the Insert, Bing Maps icon. I also suppress the Bing Maps App and recreates it to no avail. The error is invalid locations (see link).
- For testing purposes, i'm using the same data shown in the example : https://1drv.ms/i/s!AqRP0RQrhNWWyAmsAuMHDG80dP99 I connect to Bing Maps using the Insert, Bing Maps icon. I also suppress the Bing Maps App and recreates it to no avail. The error is invalid locations (see link).
Daniel, from my point of view that's buggy and ugly add-in. And not supported by Microsoft, at least no updates from mid of 2014.
However, since have it still installed, i tried - and it works. After the error i just pushed Show Locations button.
If don't use 3D maps and Power View, the alternative could be recently introduced Maps Chart, however it's on preview stage and require O365 subscription.
Thanks for answering. Unfortunately, pressing the "Show Locations button" just signals that "Les données sont vides" (meaning : empty data). The two others columns of data are correctly read
Maybe it has something to do with local versions.
Not working for me either.
I have a Hungarian Excel. It says invalid locations ("Érvénytelen helyek"), and the cities are listed from the first column.
:(
There is a way to map city data in Excel and after playing around with this for hours I figured it out, wrote it up and created a video
https://www.urtech.ca/2019/01/solved-video-easy-way-to-plot-cities-on-a-map-using-excel/
I hope this helps... I would have saved me a pile of frustration.
